-
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.
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
|