ASM user: Not able to grant SELECT on V_$DATABASE and V_$TRANSPORTABLE_PLATFORM

Apr 15, 2016 10:00AM · Apr 15, 2016 10:00AM

I created a user on ASM instance and trying to assign SELECT privileges on V_$DATABASE and V_$TRANSPORTABLE_PLATFORM tables.

sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 15 08:53:43 2016

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME

--------------- ----------------

HOST_NAME

----------------------------------------------------------------

VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE

----------------- -------------------- ------------ --- ---------- -------

LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST

--------------- ---------- --- ----------------- ------------------ ---------

Storage Management (ASM ACFS DNFS ODM) (MOSC)