Hi,
How to grant SELECT privileges on v_monitor and v_catalog tables to user? Some of the system tables are not accessible and getting the following error message?
select * from active_events;
ERROR: Permission denied for relation active_events
Granting privileges on v_monitor and v_catalog schemas
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Granting privileges on v_monitor and v_catalog schemas
Maybe try a DB view?
Example:
Example:
Code: Select all
dbadmin=> create user jim;
CREATE USER
dbadmin=> create view public.active_events_vw as select * from v_monitor.active_events;
CREATE VIEW
dbadmin=> grant select on public.active_events_vw to jim;
GRANT PRIVILEGE
dbadmin=> \c dbadmin jim
You are now connected to database "dbadmin" as user "jim".
jim=> select count(*) from public.active_events_vw;
count
-------
3
(1 row)
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Granting privileges on v_monitor and v_catalog schemas
If that actually works I'll pleasantly surprised. The official word I got from Vertica is that you need dbadmin to query system tables (6.1.3). I'm guessing this is only possible with 7.0.
Checkout vertica.tips for more Vertica resources.
Re: Granting privileges on v_monitor and v_catalog schemas
Even in 7.0 this is not working. Granted user can see the data, if that data is relevant to him/her.
Lets hope future versions of vertica will provide access to all data dictionary views/tables just with a simple grant
or via a role.
Lets hope future versions of vertica will provide access to all data dictionary views/tables just with a simple grant
or via a role.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Granting privileges on v_monitor and v_catalog schemas
The functionality still doesn't exist as of 7.1. There is an enhancement request for this functionality and hopefully we will see it in future versions.
Checkout vertica.tips for more Vertica resources.