AIM : To avoid a user to connecting to Database using connect /as sysdba
After the User log-in to OS,We can follow two methods.
STEP 1 : In sqlnet.ora file modify the following line to SQLNET.AUTHENTICATION_SERVICES=(NONE)
STEP 2 : Remove dba group to the user who is logging in to the system.
Note : orapwd file is used to authenticate users over the network only.users who already logged in to the system can’t be restricted to connect ‘/as sysdba’
No comments:
Post a Comment