When you connect as sysdba issuing a 'CONNECT / AS SYSDBA', Oracle checks if your account is a member of the os group 'ORA_sid_DBA' or 'ORA_DBA' group.
Operating System Group | UNIX User Group | Windows User Group |
---|---|---|
OSDBA | dba | ORA_DBA |
OSOPER | oper | ORA_OPER |
To make a user an administrative user simply:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
That user should now be able to “connect / as sysdba”
If the check requirements are not met, you receive an ORA-01031 error.
C:\Documents and Settings\gerardnico>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 9 14:28:12 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges