SQL> select * from dba_sys_privs where grantee = 'TEST';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TEST CREATE ANY DIRECTORY NO
TEST CREATE VIEW NO
TEST UNLIMITED TABLESPACE NO
SQL> select * from dba_role_privs where grantee = 'TEST';
GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
TEST CONNECT NO YES
TEST RESOURCE NO YES
SQL> select * from dba_tab_privs where grantee = 'TEST';
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
---------- ---------- ---------- ---------- ---------- --- ---
TEST SYS DATA_PUMP_ SYS WRITE NO NO
DIR
TEST SYS DATA_PUMP_ SYS READ NO NO
DIR
TEST SYS DBDMP SYS WRITE YES NO
TEST SYS DBDMP SYS READ YES NO
TEST SYS DBDMP SYS EXECUTE YES NO
TEST SYS DBDMPY SYS WRITE YES NO
TEST SYS DBDMPY SYS READ YES NO
TEST SYS DBDMPY SYS EXECUTE YES NO
TEST SYS DMP SYS WRITE YES NO
TEST SYS DMP SYS READ YES NO
TEST SYS DMP SYS EXECUTE YES NO
SQL> select owner, object_type, object_name, created from dba_objects where created >= to_date('2015-05-13','yyyy-mm-dd') order by 4;
OWNER OBJECT_TYPE OBJECT_NAME CREATED
---------- ------------------- ------------------------- ---------
SYS TABLE PARTITION WRH$_FILESTATXS 13-MAY-15
SYS INDEX PARTITION WRH$_FILESTATXS_PK 13-MAY-15
SYS TABLE PARTITION WRH$_FILESTATXS 14-MAY-15
SYS INDEX PARTITION WRH$_FILESTATXS_PK 14-MAY-15
SYS TYPE SYS_PLSQL_9006_711_1 14-MAY-15
SYS TYPE SYS_PLSQL_9006_4106_1 14-MAY-15
SYS TYPE SYS_PLSQL_9006_DUMMY_1 14-MAY-15
SYS TYPE SYS_PLSQL_9006_729_1 14-MAY-15
SYS TYPE SYS_PLSQL_9006_4134_1 14-MAY-15
SYS TABLE PARTITION WRH$_FILESTATXS 15-MAY-15
SYS INDEX PARTITION WRH$_FILESTATXS_PK 15-MAY-15
SYS INDEX PARTITION WRH$_FILESTATXS_PK 15-MAY-15