How do you enable to a user to have select permission on all tables..for tables that currently exist
+1Hi, 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!
+2Hi, 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
+1Good 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
+2This 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
Hi,
Has this feature shipped in a new release?
Thanks,
Vinay
Has this feature shipped in a new release?
Thanks,
Vinay
Do we know approximately by when this feature will be enabled?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
