The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
alter schema "public" default include privileges
I'd like all existing users within schema public to access recently created tables.
Normally I just run "ALTER SCHEMA myschea DEFAULT INCLUDE PRIVILEGES;"
But this fails for schema public
. Adding quotes doesn't seem to help.
db=> alter schema "public" default include privileges; ROLLBACK 4953: The name "public" is a reserved name
0
Answers
Include the DB name... Like this:
perfect, thanks for the fast reply!