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:
create or replace view sys.bla_x$kglob as select * from sys.x$kglob; create or replace public synonym x$kglob for sys.bla_x$kglob; grant select on sys.bla_x$kglob to dba;
It works. Be happy with that.
Matheus.