Does sys auomatically have sysdba priveledges?
I tried to grant sysdba to sys but it failed.
Below is what I did:
SQL> connect internal
SQL> grant sysdba to sys;
grant sysdba to sys
ERROR at line 1:
ORA-01994: GRANT failed: cannot add users to public password file
SO I DID:
SQL> show parameter password
NAME TYPE VALUE
-------------------------- ------- -----
remote_login_passwordfile string NONE
According to ORA-01994 I need set the password file to exclusive which I did.
So I started the database as follows and got an error:
ORACLE instance started.
Total System Global Area 45268884 bytes
Fixed Size 73620 bytes
Variable Size 31916032 bytes
Database Buffers 13107200 bytes
Redo Buffers 172032 bytes
ORA-01990: error opening password file
All I want is to grant sysdba to sys.
Connecting as Internal is the same as
connect sys/pwd as sysdba
so when you are connecting as internal and granting privileges to sys you are granting privileges to yourself. Its possible that your password file is corrupt. You should use the ORAPWD command to recreate it. You will want to delete/rename the file before you try to recreate it.
Okay lets make this as simple as possible.
What user should I connect as inorder to give
sys the sysdba priveledge?
you have to create your password file if you wanna use that feature
Usage: orapwd file= password= entries=
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
Be sure about entries=n because you cannot grant sysdba to users beyond n.
[Edited by Raminder on 11-26-2001 at 11:27 PM]
Click Here to Expand Forum to Full Width