Hi all!
While selecting on x$kglob with DBA credentials hanging on:
SQL> select count(*) from sys.x$kglob; ERROR at line 1: ORA-00942: a tabela ou view não existe
But with sys it succeed. Ok, let’s grant privilege:
SQL> grant select on sys.x$kglob to dba; grant select on sys.x$kglob to dba * ERROR at line 1: ORA-02030: can only select from fixed tables/views
What a hell! I couldn’t grant it any way!
So the MCGayver solution was:
More“x$kglob: ORA-02030: can only select from fixed tables/views”