另外,如果查询某个角色包含哪些系统权限的话,可以查询: (1)、系统权限: select * from role_sys_privs; 【用字段role过滤】 ROLE_SYS_PRIVSROLE_SYS_PRIVS:describes system privileges granted to roles. Information is provided only about roles to which the user has access
(2)、对象权限: select * from role_tab_privs; 【用字段role过滤】 ROLE_TAB_PRIVSROLE_TAB_PRIVS:describes table privileges granted to roles. Information is provided only about roles to which the user has access.
(3)、角色里都包含哪些角色: select * from role_role_privs 【用字段role过滤】 ROLE_ROLE_PRIVSROLE_ROLE_PRIVS:describes the roles granted to other roles. Information is provided only about roles to which the user has access.