Page 1 of 1

Granting privileges to v_ schemas

Posted: Tue Jan 28, 2014 3:19 pm
by NorbertKrupa
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:

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
Is there any way to grant privileges to select on v_monitor.license_audits?

Re: Granting privileges to v_ schemas

Posted: Tue Sep 15, 2015 2:34 pm
by az3
I also need to grant this kind of access. Is there any way? Can anyone, other than "dbadmin" access this tables?

Maybe generating a proxy schema will also work. A cronjob like ETL that copies data from the v_monitor tables into our own schema. It can run every 10 mins or so?

But I prefer a native and easier way (:

Re: Granting privileges to v_ schemas

Posted: Tue Sep 15, 2015 3:25 pm
by NorbertKrupa
Currently, the only work around is to copy to a user table and grant permissions. However, there could be some improvements in an upcoming release.