how to grant sysdba privileges to user

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ramanan ram
    New Member
    • Feb 2012
    • 26

    how to grant sysdba privileges to user

    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..
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Code:
    GRANT SYSDBA TO <USERNAME>
    But only user with SYSDBA privilege can do that.

    Comment

    • ramanan ram
      New Member
      • Feb 2012
      • 26

      #3
      rski i tried this query but insufficient privileges error display ..
      thanks in advance..

      Comment

      • bharthi
        New Member
        • Jun 2012
        • 20

        #4
        Hi Ramanan sir ,
        Try this one,

        grant connect ,resource,DBA to USER

        Comment

        Working...