- 查看某用户的系统权限
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';