李大仁博客

-- 创建readonly_user用户，密码为readonly_password
CREATE USER readonly_user WITH encrypted password 'readonly_password';
-- 设置readonly_user用户为只读事务
ALTER USER readonly_user SET default_transaction_read_only=ON;
-- 授予usage权限给到readonly_user用户
GRANT usage ON schema "public" TO readonly_user;
-- 将默认"public"schema下新建表的读取权限授予给readonly_user
ALTER DEFAULT privileges IN schema "public" GRANT SELECT ON TABLES TO readonly_user;
-- 授予select权限给到readonly_user用户
GRANT SELECT ON ALL TABLES IN schema "public" TO readonly_user;
GRANT SELECT ON ALL sequences IN schema "public" TO readonly_user;
-- 允许readonly_user用户连接到指定数据库
GRANT CONNECT ON DATABASE splrp_dev TO readonly_user;

-- 创建readonly_user用户，密码为readonly_password create user readonly_user with encrypted password 'readonly_password'; -- 设置readonly_user用户为只读事务 alter user readonly_user set default_transaction_read_only=on; -- 授予usage权限给到readonly_user用户 grant usage on schema "public" to readonly_user; -- 将默认"public"schema下新建表的读取权限授予给readonly_user alter default privileges in schema "public" grant select on tables to readonly_user; -- 授予select权限给到readonly_user用户 grant select on all tables in schema "public" to readonly_user; grant select on all sequences in schema "public" to readonly_user; -- 允许readonly_user用户连接到指定数据库 grant connect on database splrp_dev to readonly_user;

-- 授予usage权限给到readonly_user用户
GRANT usage ON schema "public" TO readonly_user;
-- 授予select权限给到readonly_user用户
GRANT SELECT ON ALL TABLES IN schema "public" TO readonly_user;
GRANT SELECT ON ALL sequences IN schema "public" TO readonly_user;

-- 授予usage权限给到readonly_user用户 grant usage on schema "public" to readonly_user; -- 授予select权限给到readonly_user用户 grant select on all tables in schema "public" to readonly_user; grant select on all sequences in schema "public" to readonly_user;

-- 将默认"public"schema下新建表的读取权限授予给readonly_user
ALTER DEFAULT privileges IN schema "public" GRANT SELECT ON TABLES TO readonly_user;

-- 将默认"public"schema下新建表的读取权限授予给readonly_user alter default privileges in schema "public" grant select on tables to readonly_user;