Hi,
How can I give SYSDBA or SYSOPER role to users ?
Thanks inAdvance
Ravi
Printable View
Hi,
How can I give SYSDBA or SYSOPER role to users ?
Thanks inAdvance
Ravi
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
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
darshil,
The parameter name is REMOTE_LOGIN_PASSWORDFILE, not REMOTE_LOGIN_PASSWORD_FILE. I had problem once because of the spelling.
Adriano.