Grant Access to all objects in schema PostgreSQL

Sometimes we have to grant access to all objects(tables, views, stored procedures,….) of schema. This can be done with the following command.

GRANT SELECT ON ALL TABLES IN SCHEMA accounts to john;

To grant this access, user must have GRANT privileges on the SCHEMA. But, not for superusers.
To Create user, we must be superuser or createrole or createuser privilege.

Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: