x$kglob: ORA-02030: can only select from fixed tables/views

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.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.