查询哪个用户对schema.table有权限:
select * from dbc.allrights where databasename='schema' and tablename='table'
查询哪个角色对schema.table有权限:
select * from dbc.allrolerights where databasename='schema' and tablename='table'
或者图形界面里选中该表点右键,有个Rights选项
查询一个角色对哪些表有权限:
select * from dbc.allrolerights where rolename='role'
查询一个角色有哪些用户与之关联:
select * from dbc.rolemembers where rolename='xxxx'
查询一个用户具有什么角色:
select * from dbc.rolemembers where grantee ='username';