How do you enable to a user to have select permission on all tables..for tables that currently exist
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!