KingbaseES-v8r6-查看用户系统权限和对象权限

• 查看某用户的系统权限

SELECT * FROM  sys_roles WHERE rolname='SYSTEM';

• 查看某用户的表权限

select * from information_schema.table_privileges where grantee='SYSTEM';

• 查看usage权限表

select * from information_schema.usage_privileges where grantee='SYSTEM';

• 查看存储过程函数相关权限表

select * from information_schema.routine_privileges where grantee='SYSTEM';