Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Audit SYSDBA user login Information

AbkAug 1 2009 — edited Aug 3 2009
Hi All,

Can any body explain about that username column in v$session view represent the username as sys even though i create the username as *"a"*


as following syntax

SQL> create user a identified by a;

User created.

SQL> grant sysdba to a;

Grant succeeded.

SQL> conn a/a as sysdba
Connected.

SQL> show user
USER is "SYS"

SQL> select username from v$session;

USERNAME
------------------------------
SYS


if i repeat the same syntax with user *"b"* . How i can identified which sysdba privileged user logged in . *'a' or 'b'*
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2009
Added on Aug 1 2009
9 comments
1,814 views