Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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


Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.