-
Does sys auomatically have sysdba priveledges?
I tried to grant sysdba to sys but it failed.
Below is what I did:
SQL> connect internal
Connected.
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
SQL>
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:
SQL> startup
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
'/oracle/app/oracle/product/8.1.7/dbs/orapw'
All I want is to grant sysdba to sys.
Any help?
-
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
-
C:\>orapwd
Usage: orapwd file= password= entries=
where
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]
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
|