How do you enable to a user to have select permission on all tables..for tables that currently exist

Sam_2

Hi, I'm wondering if there's a way to that a role/user can have SELECT access to all tables that currently exist in vertica and will be made going forward. I ran "grant SELECT on ALL TABLES in SCHEMA public to reportgen_user" where reportgen_user is a role. and this worked on fine on Vertica 6.1 -- but for all new tables after the grant is run - well, you get a permission denied error. To allow access, I have to run the grant command again. Is this the normal behavior? Is there something I can run which allow "automatic permissioning" for all new tables? Or will I need to remember to grant selects after each new table is created? Thanks in advance!

[Deleted User]

Hi, Unfortunately this is the way that it works now. There is a feature request to change the behavior for the new tables too, but there is not a release date. Sorry for the inconvenience. Eugenia

Sam_2

Good to know. It's a tad annoying, but I can set up some sort of job to detect new tables and run the grant. Thanks for the quick response! Samir

[Deleted User]

This is the way that other customer workaround this inconvenience, or not even look for new tables, the run the grant constantly. Keep on eye in release notes, maybe one release you will find that it was resolved. Eugenia

Vinay_Kola

Hi, 

Has this feature shipped in a new release? 

Thanks,
Vinay

vbagare

Do we know approximately by when this feature will be enabled?