RE: Connecting as sysdba

From: <oracle-l-bounce_at_freelists.org>
Date: Tue, 1 Jun 2004 13:10:09 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C325@25exch1.vicorpower.vicr.com>

One also needs to have a password file. Not required, unless you want to be able to.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----

From: Zeng, Lei
Sent: Tuesday, June 01, 2004 1:00 PM
To: oracle-l_at_freelists.org
Subject: RE: Connecting as sysdba

To my knowledge, for a user account to be able to 'connect as sysdba', it needs to be granted 'SYSDBA' privilege (use 'GRANT SYSDBA to USER' command). To check which user account is currently having SYSDBA privilege, query table v$PWFILE_USERS .

Lei

-----Original Message-----

From: syed jaffar hussain [mailto:sjaffarhussain_at_hotmail.com] Sent: Sunday, May 30, 2004 9:57 AM
To: oracle-l_at_freelists.org
Subject: Connecting as sysdba

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


-----------------------------------------------------------------

----------------------------------------------------------------

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 Tue Jun 01 2004 - 12:12:51 CDT