Granting privileges to v_ schemas

Moderator: NorbertKrupa

Post Reply
NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Granting privileges to v_ schemas

Post by NorbertKrupa » 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:

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?
Checkout vertica.tips for more Vertica resources.

az3
Newbie
Newbie
Posts: 1
Joined: Tue Sep 15, 2015 2:29 pm

Re: Granting privileges to v_ schemas

Post by az3 » Tue Sep 15, 2015 2:34 pm

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 (:

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Granting privileges to v_ schemas

Post by NorbertKrupa » Tue Sep 15, 2015 3:25 pm

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.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica Security”