| Main Menu
Online
|
|
Posted by: admin on Sep 02, 2009 - 07:45 PM
PostNuke
|
To disable a user to connecting to Database login using connect "/ as sysdba" after login to OS :
1. In $ORACLE_HOME/network/admin/sqlnet.ora file modify the following line to
SQLNET.AUTHENTICATION_SERVICES=(NONE)
2. Restart listener, with this command :
lsnrctl stop
lsnrctl start
or
Remove dba group to the user who is logging in to the OS.
Note : orapwd file is used to authenticate users over the network only. Users who already logged in to the Database can not be restricted to connect '/ as sysdba' until they logout.
---
Dedi
|
|
|
|
Login
|
