PG_RLS笔记

发表于 本文字数： 415 阅读时长 ≈ 1 分钟

[TOC]

RLS

1. 启动/关闭RLS

1
2
3
4
-- 失效RLS
alter user odoo with bypassrls;
-- 生效RLS
alter user odoo with nobypassrls;

2. 查询RLS

1
2
3
4
5
6
--查询表的rls是否对表所有者生效
select relname,relrowsecurity,relforcerowsecurity from pg_class where relrowsecurity=true;
select relname,relrowsecurity,relforcerowsecurity from pg_class where relrowsecurity=false;

--查询当前表是否设置rls
select relname,relrowsecurity from pg_class where relname='tablename';