SQL

oracle privileges users

SELECT USERNAME,
       LOCK_DATE,
       EXPIRY_DATE
FROM DBA_USERS
WHERE USERNAME IN (SELECT GRANTEE
                   FROM DBA_SYS_PRIVS
                   WHERE PRIVILEGE = 'UNLIMITED TABLESPACE')
ORDER BY USERNAME;

Oracle privileges

DELETE data from a specific table.
	INSERT data into a specific table.
	CREATE a foreign key reference to the named table or to a subset of columns from a table.
	SELECT data from a table, view, or a subset of columns in a table.
	CREATE a trigger on a table.
	UPDATE data in a table or in a subset of columns in a table.
	RUN a specified function or procedure.
	USE a sequence generator or a user-defined type.