DBA and SysDBA role
750397Jan 31 2010 — edited Feb 1 2010Hi,
I'm very new to Oracle and I want to give my new user/schema the privilege to be a sysdba.
In SQLPlus, when I grant sysdba to myuser, it confirms that the grant is succeeded but when I query DBA_Role_privs there is no row for SysDBA. However, when I grant dba to myuser and query DBA_Role_Privs there is a row for DBA.
My question is that is the DBA role the same as the SysDBA? Why did it confirm that SysDBA was created when it clearly wasn't?
Many thanks for your help