SELECT only access to SYSTEM tables

Hi, I am creating a user for monitoring performance etc... How can I grant SELECT to the V_MONITOR and V_CATALOG tables? I can't do GRANT SELECT ON V_MONITOR.RESOURCE_QUEUES TO MONITOR_USER; The user needs SELECT privilege to the system tables and I don't want the user having Insert/Update/Delete privileges on any table. Thanks, Sean

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file