Audit SYSDBA user login Information
AbkAug 1 2009 — edited Aug 3 2009Hi 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'*