hi,syed jaffar hussain you may create another os user and the os user are not in the same group with your oracle owner. Best regards yahoo id: feng_chunpei A new dba from china ---- from the mail----- >Hello list, > >I have noticed onething, when I logon to my UNIX as oracle user, I am >able to connect to the database as sysdba from any database user. > >Sqlplus /nolog >Connect user_1/password as sysdba; > >I want to prevent all DB users, except sys, to connect as sysdba. How >can I do it? I tried to change the remote_login_passwordfile values but >vain. > >Is this expected behaviour or do I have to change anything in the >init.ora file? > >Regds >Jaffar >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >put 'unsubscribe' in the subject line. >-- >Archives are at //www.freelists.org/archives/oracle-l/ >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- > >. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------