How to create a request to select privileges by users?

Question

Oracle

There is a system user (SYSTEM) in the Oracle database and let's say my user my_user to which I assigned certain rights
, so you need to make a query that would display a table of this kind (dots are a space filler)
+------------ ---------------+----------+-----------+
| Privilege name | SYSTEM | my_user |
+--------------------------------+----------+---------- -+
| create table....|..YES.......|...YES......|
+--------------------------------+----------+---------- -+
| create index.................|..YES......|...NO........|
+--------------------------------+----------+---------- -+
etc
That is, the name of the privilege is the first column, the second YES or NO does the user SYSTEM have this privilege and the 3rd column YES or NO does the user my_user have this privilege
Help write a query, which tables it needs to be done, how to present data from them in in this form?

Answer 1

So?

SELECT T1.PRIVILEGE, 
       T1.ADMIN_OPTION  SYS_USER,
       T2.ADMIN_OPTION  MY_USER 
  FROM DBA_SYS_PRIVS T1 
       LEFT JOIN DBA_SYS_PRIVS T2 ON T1.PRIVILEGE = T2.PRIVILEGE 
                           AND T2.GRANTEE = 'MY_USER'
  WHERE T1.GRANTEE = 'SYS'
  ORDER BY T1.PRIVILEGE ASC