Skip to content

Instantly share code, notes, and snippets.

@mator

mator/gist:f3af982c45395e2453e149f23c78f8b4

Created September 2, 2022 13:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mator/f3af982c45395e2453e149f23c78f8b4 to your computer and use it in GitHub Desktop.
Save mator/f3af982c45395e2453e149f23c78f8b4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
read-only доступ для пользователя readonly до базы db1 для PostgreSQL версии меньше чем 14.x:
\c db1
CREATE USER readonly WITH PASSWORD 'xxx';
GRANT CONNECT ON DATABASE db1 TO readonly;
GRANT USAGE ON SCHEMA public TO readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;
с версии 14.x появилась возможность использовать predefined role "pg_read_all_data" (заменяющая последние две команды SQL: USAGE/SELECT) :
GRANT pg_read_all_data TO userA;
PS: так же, в 14-й версии появилась роль pg_write_all_data
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment