RE: sysdba

From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 12 Jul 2004 10:35:35 -0700
There is no more svrmgr. Only SQL*Plus.
To connect as sysdba, you say:
Connect sys/password as sysdba
Or
Connect username/password as sysdba
If the username has the sysdba privilege.
If user X has sysdba privilege, then after a
Connect X/password as sysdba
The "show user" command will show that you are connected as SYS, not X.

Look in v$pwfile_users to see the users that can sign on as SYSDBA.

You can sign on as sysdba remotely if parameter
REMOTE_LOGIN_PASSWORDFILE =3D EXCLUSIVE.=20

Finally, if parameter O7_DICTIONARY_ACCESSIBILITY =3D FALSE (the =
default),
then user SYS cannot connect unless you say "as sysdba".
If O7_DICTIONARY_ACCESSIBILITY =3D TRUE then you can say "connect
sys/password" without specifying "as sysdba".

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Spears, Brian
Sent: lundi, 12. juillet 2004 06:47
To: oracle-l@xxxxxxxxxxxxx
Subject: sysdba


 Someone was telling me connecting as sysdba from sqlplus is not allowed
in
9i. I tried and found it did seem to not be available. Is this a
security
consideration... And/or does anyone have a workaround?

Thanks
Brian

----------------------------------------------------------------
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
-----------------------------------------------------------------
RE: sysdba

Other related posts:
