SYSDBA [message #234168] |
Mon, 30 April 2007 04:54 |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
hi,
i loged in to a server as admin user (ORA_DBA group in windows).When i tried to connect using Connect "/ as SYSDBA" ,i get error insufficient privilleges.What could be the reason here ?Does it mean SYS dont have SYSDBA prililege ?
|
|
|
|
|
Re: SYSDBA [message #234552 is a reply to message #234410] |
Wed, 02 May 2007 02:04 |
tahpush
Messages: 961 Registered: August 2006 Location: Stockholm/Sweden
|
Senior Member |
|
|
Have you checked that sys have been granted the sysdba role ?
dwadm@DW.US.ORACLE.COM> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER
------------------------------ ------ -------
SYS TRUE TRUE
[Updated on: Wed, 02 May 2007 02:27] Report message to a moderator
|
|
|
|
Re: SYSDBA [message #234569 is a reply to message #234168] |
Wed, 02 May 2007 09:42 |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
re-iterating...
my OS user is under ORA_DBA group in windows
SYS is granted SYSDBA, i can connect as sys/welcome as SYSDBA
SQLNET.AUTHENTICATION_SERVICES= (NTS)
a question.Does password file has any role to play here ?
|
|
|
Re: SYSDBA [message #234573 is a reply to message #234168] |
Wed, 02 May 2007 10:03 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>a question.Does password file has any role to play here ?
IMO, no it does not.
If you are desperate, you could try
SQLNET.AUTHENTICATION_SERVICES= (NONE)
|
|
|