Analyze privileges assigned to tables by a grouping of 'GRANTEE'. This view does not provide specifics related to the level of privileges assigned by 'GRANTEE'. 

Instructions:

1. Login to Oracle SQL*Plus as user 'system'. 

2. Run the following SQL statement. 

SELECT COUNT(DISTINCT(TABLE_NAME)) TABLE_NO, OWNER, GRANTEE
FROM DBA_TAB_PRIVS WHERE OWNER NOT LIKE '%SYS%'
GROUP BY OWNER, GRANTEE ORDER BY 2;

Sample Results:
SQL> SELECT COUNT(DISTINCT(TABLE_NAME)) TABLE_NO, OWNER, GRANTEE
  2  FROM DBA_TAB_PRIVS WHERE OWNER NOT LIKE '%SYS%'
  3  GROUP BY OWNER, GRANTEE ORDER BY 2;

  TABLE_NO OWNER                          GRANTEE
---------- ------------------------------ ------------------------------
        65 CRPCTL                         JDE_NONPROD
        65 CRPCTL                         JDE_ROLE
      3333 CRPDTA                         JDE_NONPROD
      3333 CRPDTA                         JDE_ROLE
         7 DBSNMP                         OEM_MONITOR
        12 DD812                          JDE_NONPROD
        12 DD812                          JDE_ROLE
        47 DV812                          JDE_NONPROD
        47 DV812                          JDE_ROLE
        13 OL812                          JDE_NONPROD
        13 OL812                          JDE_ROLE

  TABLE_NO OWNER                          GRANTEE
---------- ------------------------------ ------------------------------
         5 ORDPLUGINS                     PUBLIC
         3 OUTLN                          SELECT_CATALOG_ROLE
        47 PD812                          JDE_ROLE
        65 PRODCTL                        JDE_ROLE
      3333 PRODDTA                        JDE_ROLE
        47 PS812                          JDE_NONPROD
        47 PS812                          JDE_ROLE
        77 PS812CTL                       JDE_NONPROD
        77 PS812CTL                       JDE_ROLE
      3333 PS812DTA                       JDE_NONPROD
      3333 PS812DTA                       JDE_ROLE

  TABLE_NO OWNER                          GRANTEE
---------- ------------------------------ ------------------------------
        47 PY812                          JDE_NONPROD
        47 PY812                          JDE_ROLE
         7 SVM812                         JDE_NONPROD
         7 SVM812                         JDE_ROLE
       295 SY812                          JDE_NONPROD
       295 SY812                          JDE_ROLE
        65 TESTCTL                        JDE_NONPROD
        65 TESTCTL                        JDE_ROLE
      3333 TESTDTA                        JDE_NONPROD
      3333 TESTDTA                        JDE_ROLE
       187 XDB                            PUBLIC

  TABLE_NO OWNER                          GRANTEE
---------- ------------------------------ ------------------------------
         1 XDB                            XDBADMIN

34 rows selected.

SQL> 