Science without religion is lame. Religion without science is blind.

— Albert Einstein

ORACLE - Pivilege, Data Dictionary View

Data Dictionary Views for System/Object Privileges

Data Dictionary View Description
ROLE_SYS_PRIVS System privileges granted to roles
ROLE_TAB_PRIVS Table privileges granted to roles
USER_ROLE_PRIVS Roles accessible by the user
USER_TAB_PRIVS_MADE Object privileges granted on the user’s
objects
USER_TAB_PRIVS_RECD Object privileges granted to the user
USER_COL_PRIVS_MADE Object privileges granted on the
columns of the user’s objects
USER_COL_PRIVS_RECD Object privileges granted to the user on
specific columns
USER_SYS_PRIVS System privileges granted to the user