DBA Role, How and Why
DBA Role In Oracle database, DBA could be the most privileged role. Whenever we want to make a user to be the most dominant application… Read More »DBA Role, How and Why
Dynamic View
SELECT_CATALOG_ROLE, How and Why
SELECT_CATALOG_ROLE Oracle designs several privileges and roles for users who want to query database dictionary views. Two of them are usually used by DBA to… Read More »SELECT_CATALOG_ROLE, How and Why
How to Resolve ORA-02030: can only select from fixed tables/views
ORA-02030 Tried to grant SELECT object privilege of V$SESSION to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant… Read More »How to Resolve ORA-02030: can only select from fixed tables/views
Who has SYSDBA Privilege?
SYSDBA Privilege SYSDBA is a system privilege. By default, only SYS has the privilege, but it can be changed by granting to other user. Although… Read More »Who has SYSDBA Privilege?