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!