| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sysdba
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Spears, Brian
Sent: lundi, 12. juillet 2004 06:47
To: oracle-l_at_freelists.org
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
 |
 |