Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

SQL Error [42501]: ERROR: permission denied for table

ALTER DEFAULT PRIVILEGES FOR ROLE creator IN SCHEMA public GRANT SELECT ON TABLES TO readonly;
Source by dba.stackexchange.com #
 
PREVIOUS NEXT
Tagged: #SQL #Error #permission #denied #table
ADD COMMENT
Topic
Name
5+3 =