AnatomicJC/postgresql-read-only-user.md

## postgresql-read-only-user.md

      
        

                Raw

        
        
          
            
          
          
            
              postgresql-read-only-user.md
            
          
        
      
      
    CREATE ROLE "ro-user" WITH PASSWORD 'secret';
ALTER ROLE "ro-user" WITH LOGIN;
GRANT USAGE ON SCHEMA public TO "ro-user";
GRANT SELECT ON ALL TABLES IN SCHEMA public TO "ro-user";
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO "ro-user";