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
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: 10706
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.
Previous Topic: Regarding PAckage security
Next Topic: DBA role
Goto Forum:

Current Time: Sun Dec 04 22:40:50 CST 2022