SYSDBA privlieges

[helloravi]

Hi,

How can I give SYSDBA or SYSOPER role to users ?


Thanks inAdvance

Ravi

[rotem_fo]

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

[darshil_db]

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

[adrianomp]

darshil,

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



Adriano.