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

Thread: SYSDBA privlieges

  1. 03-08-2001, 12:36 AM #1
    helloravi
    helloravi is offline Junior Member
    Join Date
    Aug 2000
    Posts
    33
    Hi,

    How can I give SYSDBA or SYSOPER role to users ?


    Thanks inAdvance

    Ravi
    Reply With Quote Reply With Quote
  2. 03-08-2001, 04:44 AM #2
    rotem_fo
    rotem_fo is offline Hangin Around,,,
    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
    Reply With Quote Reply With Quote
  3. 03-08-2001, 05:46 AM #3
    darshil_db
    darshil_db is offline Junior Member
    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
    Reply With Quote Reply With Quote
  4. 03-08-2001, 08:49 AM #4
    adrianomp's Avatar
    adrianomp
    adrianomp is offline Senior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width