RE: Connecting as sysdba

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@xxxxxxxxxxxxx
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@xxxxxxxxxxx] 
Sent: Sunday, May 30, 2004 9:57 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: