The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

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