View the differences in permissions between roles in Oracle

There is no SQL statement in Oracle to check the difference in permissions between roles. 1. view the system permissions of the current user. select * fromsession_privs; 2. view All roles in the database, selec * fromdba_roles; 3. view the maximum number of roles supported by the database SQLshowparameterrolemax_enabled_rolesinteger1

There is no SQL statement in Oracle to check the difference in permissions between roles. 1. view the system permissions of the current user. select * from session_privs; 2. view All roles in the database, selec * from dba_roles; 3. view the maximum number of roles supported by the database SQL show parameter rolemax_enabled_roles integer 1

SQL statement in Oracle to view the differences in permissions between roles
<无>

1. view the system permissions of the current user. select * from session_privs; 2. view All roles in the database, selec * from dba_roles; 3. view the maximum number of roles supported by the database SQL> show parameter rolemax_enabled_roles integer 150 -- this value can be modified to OS _roles boolean FALSEremote_ OS _roles boolean FALSE4. view the role select * from session_roles; 5. view the nested relationship of the role and the user selected * from dba_role_privs order by 1; 6. other commands for viewing roles and permissions: select * from role_sys_privs; select * from dba_sys_privs; 7. table-level object permission select * From user_tab_privs_made; select * from user_tab_privs_recd; 8. select * from user_col_privs_made; select * from user_col_privs_recd; 9. compare the permission differences between connect and resoucr roles. SQL> select grantee, privilege from dba_sys_privs where grantee = 'resource' or grantee like 'connect % 'CONNECT CREATE VIEWCONNECT CREATE TABLECONNECT ALTER SESSIONCONNECT CREATE CLUSTERCONNECT CREATE SESSIONCONNECT CREATE SYNONYMCONNECT CREA Te sequenceconnect create database linkresource create typeresource create tableresource create clusterresource create triggerresource create operatorresource create sequenceresource create indextyperesource create procedure 16 rows have been selected. 10. Check the oracle version. In fact, there are many other methods to check the oracle version, but I think the following method is a good note. SQL> select version from v $ instance; 10.1.0.2.0 Note: The oracle version I used in this experiment is 10.1.0.2.0. The CONNECT role has only the create session permission after 10 Gb, And the permissions of other versions have been canceled. After the RESOURCE role is granted to a user, the user automatically has the system permission of the unlimited tablespace.