PG 创建只读用户并授予指定表权限

CREATE ROLE raccess;
GRANT CONNECT ON DATABASE bludb TO raccess;
GRANT USAGE ON SCHEMA public TO raccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO raccess;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON ALL TABLES TO raccess;
ALTER DEFAULT PRIVILEGES FOR ROLE userdesa IN SCHEMA public GRANT SELECT ON ALL TABLES TO raccess;
CREATE USER rouser WITH PASSWORD 'xxxx';
#CREATE USER rouser WITH ENCRYPTED PASSWORD 'xxx';
grant raccess  to rouser;

grant  SELECT on ' || r.tablename || ' to <readonlyuser> ';

grant select on public.seg_scorp to rouser;