Connecting to PostgreSQL
If your read-only user name is
GRANT USAGE ON SCHEMA <schema_name> TO silota; GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name> TO silota;
- The first command grant the ability to list tables from a schema to a user
- The second command grant the read ability to all existing tables from that schema to the user
Next Generation SQL Data Analysis Write SQL, visualize data, and share your results. Onboarding forward-thinking teams now:
No spam, ever! Unsubscribe any time. Learn more about the product.