> >

Postgresql给数据用户添加表权限

技术运维

如果当前数据库创建了新表，非数据库管理员用户需要继续分配权限（如需要）。

查询用户和表权限

SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name = 'tableName'
  AND grantee = 'your_user';

输出示例

  grantee   |  privilege_type
------------+-----------------
 your_user  | SELECT
 your_user  | INSERT
 your_user  | UPDATE
 your_user  | DELETE
(4 rows)

添加SELECT权限

GRANT SELECT ON TABLE tableName TO your_db_user;

添加写入、更新、删除权限

GRANT INSERT, UPDATE, DELETE ON TABLE tableName TO your_db_user;

查看所有用户权限

SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name = 'tableName';

查看当前用户权限

SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name = 'tableName'
  AND grantee = current_user;

Post Comment