469,342 Members | 5,481 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

how to grant sysdba privileges to user

ramanan ram
i am using toad11.5 version ,here a schema name is(ex:sa) database name(ex:wttest).i need full backup of wttest DB.
now i am trying to get through rman(recovery manager) script in databse browser.here, its showing one message 'you must have the sysdba privilege to use RMAN'

how can i give the sysdba privilege grant to the user .
but i tried,while i am open the user in tns,mode set as sysdba .but its showing insuffient privileges..

plz help..
Jun 16 '12 #1

✓ answered by bharthi

Hi Ramanan sir ,
Try this one,

grant connect ,resource,DBA to USER

3 59591
rski
700 Expert 512MB
Expand|Select|Wrap|Line Numbers
  1. GRANT SYSDBA TO <USERNAME>
  2.  
But only user with SYSDBA privilege can do that.
Jun 16 '12 #2
rski i tried this query but insufficient privileges error display ..
thanks in advance..
Jun 20 '12 #3
bharthi
20
Hi Ramanan sir ,
Try this one,

grant connect ,resource,DBA to USER
Jul 2 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by DC_DBA | last post: by
4 posts views Thread by Amardeep Verma | last post: by
reply views Thread by Charles Cantrell | last post: by
6 posts views Thread by maxwell | last post: by
2 posts views Thread by Chris M. Gamble | last post: by
2 posts views Thread by Ray Muforosky | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.