Create new read-only user in Postgres

Change „username” and „strong_pass”

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";

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";

Otagowano postgres.Dodaj do zakładek Link.

Create new read-only user in Postgres

Dodaj komentarz Anuluj pisanie odpowiedzi

Ostatnie wpisy

Najnowsze komentarze

Kategorie

Meta