GRANT pg read all data TO xxx;

From wikieduonline
(Redirected from Pg read all data)
Jump to navigation Jump to search

GRANT pg_read_all_data TO xxx; [1]

Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to.


create role USERNAME with login password 'PASSWORD';
GRANT pg_read_all_data TO xxx; [2]

Related[edit]

See also[edit]

  • https://stackoverflow.com/a/67213972
  • https://stackoverflow.com/a/67213972
  • Advertising: