Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
PostgreSQL 用户授权
-- 创建用户
CREATE USER dbUser WITH PASSWORD 'Abc123....';
-- 数据库授权用户,此时用户还是没有读写权限,需要授权表
GRANT ALL PRIVILEGES ON DATABASE dbName TO dbUser;
-- 当前数据库下 public schema 的表都授权给 dbUser
GRANT ALL PRIVILEGES ON all tables in schema public TO dbUser;
-- 指定表授权
GRANT SELECT ON TABLE tableName TO dbUser;
-- 指定表所有权限
GRANT ALL ON tableName TO dbUser;
-- 撤销表权限
REVOKE privileges ON tableName FROM dbUser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment