select ‘grant SELECT on table ’ || schemaname || ‘.’ || tablename || ’ to read_role;’ from pg_tables
where schemaname = ‘public’
Postgresql 表权限设置
最新推荐文章于 2024-07-25 16:10:33 发布
select ‘grant SELECT on table ’ || schemaname || ‘.’ || tablename || ’ to read_role;’ from pg_tables
where schemaname = ‘public’