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;