insufficient priveleges [message #203728] |
Thu, 16 November 2006 02:41 |
jcagustin
Messages: 1 Registered: November 2006
|
Junior Member |
|
|
i tried connecting to our database using this command:
sqlplus> connect system/***@tst --- this one connects
but i cannot connect when i use sysdba
sqlplus> connect system/***@tst as sysdba ---- error: insufficient priveleges
what will be the solution to this?
did i neglected some roles of the username system?
|
|
|
Re: insufficient priveleges [message #203732 is a reply to message #203728] |
Thu, 16 November 2006 02:48 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
hi
SQL> conn system/oracle as sysdba
Connected.
[B]bcoz of sqlnet.ora in "authentication method is "NTS".[/B]
SQL> /
SP2-0103: Nothing in SQL buffer to run.
SQL> conn system/oracle as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
[B]i was change authentication method on sqlnet.ora "NTS" TO "NONE"[/B]
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> grant sysdba to system;
grant sysdba to system
*
ERROR at line 1:
ORA-01109: database not open
SQL> alter database open;
Database altered.
[B]SQL> grant sysdba to system;[/B]
Grant succeeded.
SQL> conn system/oracle as sysdba
Connected.
SQL>
You have sysdba privs to connect as sysdba user.
hope this helps
Mohammad Taj.
|
|
|