3.24 ALL_TAB_PRIVSThe ALL_TAB_PRIVS view provides the following types of privileges:
• Object privileges for which the PUBLIC is the grantee.
Indicates whether the privilege was granted with the grant option YES or NO. YES indicates that the GRANTEE (recipient of the privilege) can in turn grant the privilege to others. The value may be YES if the grantee has the administrator privileges. The value can be YES or NO. The value may be YES if the privilege is SELECT else NO.