Granting privileges on v_monitor and v_catalog schemas

[shaz001]

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

[JimKnicely]

Maybe try a DB view?

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)

[NorbertKrupa]

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.

[kodakalla]

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.

[NorbertKrupa]

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.