May 2018
Intermediate to advanced
576 pages
30h 25m
English
Privileges can be granted for objects in a schema using the GRANT command, as follows:
GRANT SELECT ON ALL TABLES IN SCHEMA sharedschema TO PUBLIC;
However, this will only affect tables that already exist. Tables created in the future will inherit privileges defined by the ALTER DEFAULT PRIVILEGES command, as follows:
ALTER DEFAULT PRIVILEGES IN SCHEMA sharedschemaGRANT SELECT ON TABLES TO PUBLIC;