Oracle Database Discussions

Normally, if we want to connect to the SYS user of an oracle database from the server side we can connect it without giving a password and like this:

cmd> sqlplus /nolog
SQL> conn / as sysdba;

This will connect the database as SYS user. Also from the client side or even from the server side connecting to SYS user can be done like :

cmd> sqlplus /nolog
SQL> conn sys@db_name as sysdba;

This connection will prompt password of SYS user.

Now my requirement is that wherever any one wants to connect to the database as SYSDBA/SYSOPER privileged user s/he must have to input the password that means s/he can't connect to the database using: CONN / AS SYSDBA but can connect using like CONN SYS@DB_NAME AS SYSDBA which will require password to authenticate.

So is there any way to restrict the SYS user connection from server side using CONN / AS SYSDBA.

--Bazlur