Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Grant read only access to user by query

sahar israelMar 26 2024

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?

Comments
Post Details
Added on Mar 26 2024
2 comments
50 views