Creating a user with SYSDBA privilege

SQL>create user mussaib identified by mussaib;

user created

SQL> grant sysdba to mussaib;

Grant succeeded.

SQL> conn mussaib/mussaib as sysdba

Connected.

SQL> show user

USER is "SYS"                     ---------- (!!!!!!!!!!!!!!!!!)

SQL> select * from v$pwfile_users ;

USERNAME                       SYSDB SYSOP SYSAS

------------------------------ ----- ----- -----

SYS                            TRUE  TRUE  FALSE

mussaib                          TRUE  FALSE FALSE

SQL> exit;

Disconnected from Oracle Database 11g Release 11.1.0.7.0 - 64bit Production

$ sqlplus mussaib/mussaib 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"              ---------- (!!!!!!!!!!!!!!!!!)