Skip to content

Instantly share code, notes, and snippets.

@engmohy90

engmohy90/read-access.sql

Forked from oinopion/read-access.sql
Last active November 29, 2020 15:43
Show Gist options
  • Save engmohy90/fb8213839d7b594554af7bf9db2d1bc4 to your computer and use it in GitHub Desktop.
Save engmohy90/fb8213839d7b594554af7bf9db2d1bc4 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. engmohy90 revised this gist Mar 22, 2020. 1 changed file with 4 additions and 2 deletions.
    6 changes: 4 additions & 2 deletions read-access.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -9,5 +9,7 @@ GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;
    ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

    -- Create a final user with password
    CREATE USER tomek WITH PASSWORD 'secret';
    GRANT readaccess TO tomek;
    CREATE USER masterread WITH PASSWORD 'masterread';
    GRANT readaccess TO masterread;
    -- Grant connect to db
    GRANT CONNECT ON DATABASE master TO masterread;
  2. @oinopion oinopion created this gist Oct 5, 2016.
    13 changes: 13 additions & 0 deletions read-access.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,13 @@
    -- Create a group
    CREATE ROLE readaccess;

    -- Grant access to existing tables
    GRANT USAGE ON SCHEMA public TO readaccess;
    GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

    -- Grant access to future tables
    ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

    -- Create a final user with password
    CREATE USER tomek WITH PASSWORD 'secret';
    GRANT readaccess TO tomek;