Granting privileges to v_ schemas

Forum to discuss Vertica security

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”

Who is online

Users browsing this forum: No registered users and 1 guest