只有针对表级的只读权限

CREATE USER gp_read WITH ENCRYPTED PASSWORD 'password';

grant select on dw.dw_user_login_log to gp_read; 授予表权限

grant all on SCHEMA dw to gp_read; 授予架构权限

\du+

\dt

SELECT * FROM pg_roles;