ROLE&TABLE PRIVELEGE-优快云博客

本文链接：https://blog.youkuaiyun.com/startay/article/details/89495481

本文详细介绍了在PostgreSQL数据库中如何使用SQL语句查询角色和用户的权限信息，包括超级用户、登录权限、数据库创建权限等。同时展示了如何查看表权限，提供了实用的SQL查询示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ROLE/USER privilege

select * from pg_roles;
rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rol
bypassrls | rolconfig | oid
----------------------+----------+------------+---------------+-------------+-------------+----------------+--------------+-------------+---------------+----
----------+------------------------------------+-------
rxxxxxxx01 | f | t | f | f | t | f | -1 | ******** | [NULL] | f
| {default_transaction_read_only=on} | 17211
pg_signal_backend | f | t | f | f | f | f | -1 | ******** | [NULL] | f
| [NULL] | 4200

select * from pg_user;
usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd | valuntil | useconfig
-------------+----------+-------------+----------+---------+--------------+----------+----------+------------------------------------
dp-postgres | 10 | t | t | t | t | ******** | [NULL] | [NULL]
axxxxxx01 | 17205 | t | f | f | f | ******** | [NULL] | [NULL]
rxxxxxx01 | 17211 | f | f | f | f | ******** | [NULL] | {default_transaction_read_only=on}

table privilege

select * from information_schema.table_privileges where grantee=''

also can use " \du+ "