Giving Grant on v$DATABASE

To give grant on v$database or any such synonym, need to follow following steps.

11:02:21 SYS@UOCQA:-> select * from dba_synonyms where synonym_name = ‘V$DATABASE’;

OWNER SYNONYM_NAME TABLE_OWNER

—————————— —————————— ——————————

TABLE_NAME

——————————

DB_LINK

—————————————————————————————————-

PUBLIC V$DATABASE SYS

V_$DATABASE

Then,

11:02:22 SYS@UOCQA:-> GRANT SELECT ON V_$DATABASE TO PUBLIC;