-
Hi All
I am trying to grant a user admin sysdba rights. I use the command grant sysdba to admin and get theerror below
ORA-01994: GRANT failed: cannot add users to public password file
I have checked my for the error code ORA-01994 and it says
ORA-01994: GRANT failed: cannot add users to public password file
Cause: A grant failed because a user could not be added to the password file. This is because the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to PUBLIC.
Action: To add a user to the password file, shutdown the database, change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to PRIVATE, and restart the database.
My question is how do I change the remote_login_passwordfile initialization parameter to PRIVATE
Thanks in advance
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
|