Home » RDBMS Server » Security » why sys when connected as sysdba
why sys when connected as sysdba [message #160274] Fri, 24 February 2006 03:13 Go to next message
orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad
Senior Member
hi friends...
why it shows username as "SYS" when a user is connected as sysdba. Can any friend suggest how to view exact username we connect as sysdba. eg:
sql>connect sys/change_on_install as sysdba
sql>show user
sql>user is "SYS"
---------------
sql>connect market/pwds as sysdba
sql>show user
sql>user is "sys"

here im confused in which user i have connected with...ofcourse both are sys but how to know where i am...suggest plz

Re: why sys when connected as sysdba [message #160277 is a reply to message #160274] Fri, 24 February 2006 03:48 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You cannot.
When you connnect as sysdba, you are logged as SYS user.
In an analogy ( and a not so correct one), consider SYSDBA to be equivalent of SUDO in UNIX. You can either login as root user or login as yourself and SUDO to root.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#10431
Previous Topic: Regarding PAckage security
Next Topic: DBA role
Goto Forum:
  


Current Time: Thu Mar 28 09:03:17 CDT 2024