DB Version: 11g
I was asked to create a non-SYS user with SYSDBA privileges. So i created this user (mndba) with all the important privileges plus the SYSDBA privilege.
When i try to connect as this newly created user(mndba), it succeeds but when i query
show user
i realize that the connected user is actually SYS and not mndba !!!! why is this happening
SQL> grant sysdba to mndba;
Grant succeeded.
SQL> conn mndba/mndba as sysdba
Connected.
SQL> show user
USER is "SYS" ---------- (!!!!!!!!!!!!!!!!!)
SQL> select * from v$pwfile_users ;
USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE
mndba TRUE FALSE FALSE
SQL> exit;
Disconnected from Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
$ sqlplus mndba/mndba as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Apr 12 07:26:29 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
SQL> show user
USER is "SYS" ---------- (!!!!!!!!!!!!!!!!!)