Table of Contents
- Give SELECT permissions on all tables to a specific user
GRANT SELECT ON ALL TABLES IN SCHEMA public TO user;
- Set SELECT permissions on all tables for all future tablesto a specific user.
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO looker;