postgres数据库查看用户权限
时间：2022-03-10 18:01
1、查看某用户的表权限
select * from information_schema.table_privileges where grantee=‘user_name‘;
2、查看usage权限表
select * from information_schema.usage_privileges where grantee=‘user_name‘;
3、查看存储过程函数相关权限表
select * from information_schema.routine_privileges where grantee=‘user_name‘;
4、建用户授权
create user user_name; alter user user_namewith password ‘‘; alter user user_namewith CONNECTION LIMIT 20;#连接数限制
本文出自 “” 博客，请务必保留此出处
postgres数据库查看用户权限,布布扣,bubuko.com
