Creating read only users in Vertica
I'm creating a read only user in Vertica using the following script. Ideally, I would like to give SELECT permissions to the entire schema but its not possible in vertica, hence I gave SELECT permissions to ALL TABLES in the schema. Now when I create a new table in the same schema, the read only user has to be given SELECT permission again on this new table else he gets a permission denied error. Is it possible to give SELECT permissions to the new and existing objects in vertica at once instead of giving permission to new objects everytime i create one?
Grant select on ALL TABLES IN SCHEMA PUBLIC to apiuser;