SQL> conn sam
Enter password:
Connected.

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
BACKUP ANY TABLE
SELECT ANY TABLE
CREATE CLUSTER
CREATE SEQUENCE
SELECT ANY SEQUENCE
CREATE PROCEDURE
EXECUTE ANY PROCEDURE
CREATE TRIGGER
CREATE TYPE
EXECUTE ANY TYPE
CREATE OPERATOR
CREATE INDEXTYPE
ADMINISTER RESOURCE MANAGER
RESUMABLE
READ ANY FILE GROUP

18 rows selected.

SQL> show user;
USER is "SAM"

SQL> conn /as sysdba
connected.

SQL> SELECT * FROM dba_sys_privs WHERE privilege = 'UNLIMITED TABLESPACE';

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
Udaya                          UNLIMITED TABLESPACE                                  NO
OUTLN                          UNLIMITED TABLESPACE                     NO
DBSNMP                         UNLIMITED TABLESPACE                     NO
T1                             UNLIMITED TABLESPACE                     NO
SYSTEM                         UNLIMITED TABLESPACE                     YES
SAM                            UNLIMITED TABLESPACE                     NO     --> SAM
U2                             UNLIMITED TABLESPACE                     NO
TSMSYS                         UNLIMITED TABLESPACE                     NO
X                              UNLIMITED TABLESPACE                     NO
SAN                            UNLIMITED TABLESPACE                     NO
SAMS                           UNLIMITED TABLESPACE                     NO

11 rows selected.

SQL> desc dba_sys_privs;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GRANTEE                                   NOT NULL VARCHAR2(30)
 PRIVILEGE                                 NOT NULL VARCHAR2(40)
 ADMIN_OPTION                                       VARCHAR2(3)

SQL>