Hi Team,
i'm searching for a way to bring read-only access to a user to specific views.
i tried to run the following queries but i think something is missing because when i run the queries i get empty result:
GRANT SELECT ON SYSMAN.MGMT$HW_CPU_DETAILS TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$METRIC_DETAILS TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$METRIC_HOURLY TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$METRIC_DAILY TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$ALERT_HISTORY TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$TARGET_PROPERTIES TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$DB_SGA TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$DB_INIT_PARAMS TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$TARGET TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$TARGET_ASSOCIATIONS TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$OS_HW_SUMMARY TO SAHAR;
GRANT SELECT ON SYSMAN.MGMT$TEMPLATE_METRICCOLLECTION TO SAHAR;
GRANT SELECT ON SYSMAN.CM$MGMT_ASM_DISKGROUP_ECM TO SAHAR;
what should i do differntly? what i need to add?