Granting privileges to v_ schemas
Posted: Tue Jan 28, 2014 3:19 pm
I'm attempting to set up privileges for select on the v_monitor schemas, however I keep getting back an unsupported access error.
What I'm trying:
Is there any way to grant privileges to select on v_monitor.license_audits?
What I'm trying:
Code: Select all
dbadmin=> GRANT SELECT ON license_audits TO svc_vertica;
ROLLBACK 5266: Unsupported access to virtual table
dbadmin=> GRANT USAGE ON SCHEMA v_monitor TO svc_vertica;
ROLLBACK 5265: Unsupported access to virtual schema