Query to get the output for object privileges, roles, system privileges with details

Please use the below query to get the output.

set echo on;
SELECT COUNT(*) AS object_priv_count
FROM dba_tab_privs
WHERE grantee = ‘A’;

set echo on;
SELECT COUNT(*) AS role_grant_count
FROM dba_role_privs
WHERE grantee = ‘A’;

set echo on;
SELECT COUNT(*) AS system_priv_count
FROM dba_sys_privs
WHERE grantee = ‘A’;

set echo on;
SELECT OBJECT_TYPE, COUNT(*) AS OBJECT_COUNT
FROM DBA_OBJECTS
WHERE OWNER = ‘A’
GROUP BY OBJECT_TYPE
ORDER BY OBJECT_TYPE;