Oracle角色查询

发表于 2013-10-11 更新于 2024-04-30 分类于 DB

Oracle角色查询

--表授权的用户
select * from all_tab_privs t  WHERE t.TABLE_NAME ='NBU_APP_INSURED';
--角色组的成员
select * from dba_role_privs s WHERE s.GRANTED_ROLE = 'R_GBSJ2EE_DML' ;

select * from dba_roles r WHERE r.ROLE ='R_GBSJ2EE_DML';