postgres – Create user and grant permission access
CREATE USER username WITH PASSWORD 'your_password';GRANT USAGE ON SCHEMA schema_name TO username;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO username;
CREATE USER username WITH PASSWORD 'your_password';GRANT USAGE ON SCHEMA schema_name TO username;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO username;