Archiwa tagu: postgres

Create new read-only user in Postgres

przez kszyh | 9 października 2024 - 12:46 |9 października 2024 Security

Dodaj komentarz

Change „username” and „strong_pass”

Transact-SQL

CREATE USER "username" WITH PASSWORD 'strong_pass'; GRANT CONNECT ON DATABASE postgres TO "username"; GRANT USAGE ON SCHEMA public TO "username"; GRANT SELECT ON ALL TABLES IN SCHEMA public TO "username"; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO "username";

1 2 3 4 5

CREATE USER "username" WITH PASSWORD 'strong_pass'; GRANT CONNECT ON DATABASE postgres TO "username"; GRANT USAGE ON SCHEMA public TO "username"; GRANT SELECT ON ALL TABLES IN SCHEMA public TO "username"; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO "username";