SYSDBA privlieges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SYSDBA privlieges

  1. #1
    Join Date
    Aug 2000
    Posts
    33
    Hi,

    How can I give SYSDBA or SYSOPER role to users ?


    Thanks inAdvance

    Ravi

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,

    either grant DBA to the user or grant these privileges:

    DELETE_CATALOG_ROLE
    EXECUTE_CATALOG_ROLE
    EXP_FULL_DATABASE
    IMP_FULL_DATABASE
    SELECT_CATALOG_ROLE

  3. #3
    Join Date
    Dec 2000
    Posts
    10
    Hi ravi,

    U can not give sysdba rights straight away. U need to keep you remote_login_password_file=exclusive. Then use orapwd utility to create a password file. Then restart the database. At that time Oracle will allow you to give sysdba right to any users. Otherwise it won't allow.

    Regards

    Darshil

  4. #4
    Join Date
    Feb 2001
    Posts
    295
    darshil,

    The parameter name is REMOTE_LOGIN_PASSWORDFILE, not REMOTE_LOGIN_PASSWORD_FILE. I had problem once because of the spelling.



    Adriano.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width