Home » RDBMS Server » Networking and Gateways » insufficient priveleges
insufficient priveleges [message #203728] Thu, 16 November 2006 02:41 Go to next message
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 Go to previous message
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.
Previous Topic: DB Link Problem from 9i Database to 8i Database
Next Topic: Listener File Missing
Goto Forum:
  


Current Time: Mon Nov 25 09:27:25 CST 2024