Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using / to connect 1
- Thread starter oradba101
- Start date
SantaMufasa
Technical User
William,
This method of logging into Oracle has to do with Oracle Corporation's strategy for allowing members of an operating system's privileged DBA group to connect to an instance that may be under "duress"/"trauma".
The only users that can use the "connect / as sysdba" method to connect to Oracle are o/s users that are already members of the DBA group. Even if you could force an otherwise-privileged user to use a username/password combination in conjunction with "...as sysdba", Oracle still shows them connected as "SYS", with "sysdba" privileges.
In direct response to your original question: No, I am not aware of a method to disable the "connect / as sysdba" login...You must manage it with o/s group privileges.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
This method of logging into Oracle has to do with Oracle Corporation's strategy for allowing members of an operating system's privileged DBA group to connect to an instance that may be under "duress"/"trauma".
The only users that can use the "connect / as sysdba" method to connect to Oracle are o/s users that are already members of the DBA group. Even if you could force an otherwise-privileged user to use a username/password combination in conjunction with "...as sysdba", Oracle still shows them connected as "SYS", with "sysdba" privileges.
In direct response to your original question: No, I am not aware of a method to disable the "connect / as sysdba" login...You must manage it with o/s group privileges.
Mufasa(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
-
1
- Thread starter
- #3
Hi, Mufasa
I found a way to disable it. Just add
SQLNET.AUTHENTICATION_SERVICES=(NONE)
to the sqlnet.ora file.
I had done something similar to the Windows environment and had a feeling that it could be done in UNIX/Linux as well.
Regards,
William Chadbourne
Oracle DBA
I found a way to disable it. Just add
SQLNET.AUTHENTICATION_SERVICES=(NONE)
to the sqlnet.ora file.
I had done something similar to the Windows environment and had a feeling that it could be done in UNIX/Linux as well.
Regards,
William Chadbourne
Oracle DBA
SantaMufasa
Technical User
William,
Good detective work...Somehow that had escaped my RADAR. Have a Purple Star for clarifying that feature.
Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
Good detective work...Somehow that had escaped my RADAR. Have a Purple Star for clarifying that feature.
Mufasa(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
- Status
Similar threads
- Locked
- Question
