Dynamic View

How to Resolve ORA-02030: can only select from fixed tables/views

by Ed Chen
March 30, 2022April 9, 2022

ORA-02030 Tried to grant SELECT object privilege to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant select on… Read More »

Who has SYSDBA Privilege?

by Ed Chen
October 13, 2012December 11, 2022

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 »