Oracle query method for users to have all system permissions

SQL> desc dba_sys_privs;   Query the system permissions owned by the object
 Name                                     Null?    Type
 ---------------------------------------- -------- ---------------------------
 GRANTEE                                  NOT NULL VARCHAR2(30)
 PRIVILEGE                                NOT NULL VARCHAR2(40)
 ADMIN_OPTION                                      VARCHAR2(3)
SQL> select * from dba_sys_privs where grantee='HR';
GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
HR                             UNLIMITED TABLESPACE                     NO
HR                             CREATE SESSION                           NO
HR                             CREATE TABLE                             NO
SQL> desc dba_role_privs;
 Name                                     Null?    Type
 ---------------------------------------- -------- ---------------------------
 USERNAME                                          VARCHAR2(30)
 GRANTED_ROLE                                      VARCHAR2(30)
 ADMIN_OPTION                                      VARCHAR2(3)
 DEFAULT_ROLE                                      VARCHAR2(3)
 OS_GRANTED                                        VARCHAR2(3)
SQL> select * from dba_role_privs where grantee='HR';The role owned by the object
GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
HR                             RESOURCE                       NO  YES
SQL> select * from role_sys_privs where ROLE='RESOURCE';  Find permissions through roles
ROLE                           PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
RESOURCE                       CREATE TRIGGER                           NO
RESOURCE                       CREATE SEQUENCE                          NO
RESOURCE                       CREATE TYPE                              NO
RESOURCE                       CREATE PROCEDURE                         NO
RESOURCE                       CREATE CLUSTER                           NO
RESOURCE                       CREATE OPERATOR                          NO
RESOURCE                       CREATE INDEXTYPE                         NO
RESOURCE                       CREATE TABLE                             NO
SQL>  select a.granted_role,,
     From dba_role_privs a,role_sys_privs b ,dba_sys_privs c
   Where a.granted_role= and = and ='HR
RESOURCE        CREATE SEQUENCE      UNLIMITED TABLESPACE
RESOURCE        CREATE INDEXTYPE     CREATE SESSION
--Looks beautiful，But this is the same value to return the result，1=1=1   3*8=24tRecord
select a.granted_role,, from dba_role_privs
a join role_sys_privs b on a.granted_role= join dba_sys_privs
c on = and ='HR';  --No effect can be achieved；
--a  Find roles owned by users
select * from dba_role_privs  grantee granted_role
-b  Find permissions you have by role
select * from role_sys_privs    1-2 role  granted_role
-c Find system permissions you have through users
select * from dba_sys_privs  1-3 grantee 
--Ideas1+2=2 => 2+3=total
select * from (select , from
 dba_role_privs a join role_sys_privs b on a.granted_role=
  union
   select , from dba_sys_privs c)
    where grantee='HR';
--The same as above--whereCondition execution faster
select , from
 dba_role_privs a join role_sys_privs b 
    on a.granted_role= where grantee='HR'
  union 
   select , from dba_sys_privs c where grantee='HR';
significance：Some permissions are not granted separately through roles、Or grant permissions separately：It is better to find out what permissions users have through collections
 ****Replenish：
--What is object permissions，Design specific permissions for a certain object；
grant select on  to hr;
Query has permissions to specific objects；
select * from dba_tab_privs where grantee='HR';
HR         SYS        YANG       SYS        WRITE      NO  NO
HR         SYS        YANG       SYS        READ       NO  NO
HR         SYS        DBMS_STATS SYS        EXECUTE    NO  NO
HR         SCOTT      DEPT       SCOTT      SELECT     NO  NO
Recycle： revoke execute on sys.DBMS_STATS from hr;