Connecting as sysdba

From: syed jaffar hussain <sjaffarhussain_at_hotmail.com>
Date: Sun, 30 May 2004 16:57:27 +0300
Message-ID: <01a501c4464e$0ab230e0$cf0a010a@ARFAN>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Sun May 30 2004 - 08:53:46 CDT