Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to recover any SYSDBA user?
Thanks for the response. I just resolved it myself:
I had to set SQLNET.AUTHENTICATION_SERVICES= (NTS) in the SQLNET.ORA
file.
Although my current user (on Windows) was member of the ORA_DBA group,
the statement: SQLNET.AUTHENTICATION_SERVICES= (NONE) made it such that
it ignored that. So no user could log on as sysdba, let alone connect
/ as sysdba.
Thanks again,
Michael
Received on Thu Jun 29 2006 - 16:57:01 CDT