Hello Gurus ;
CONNECT , RESOURCE role do not contain 'UNLIMITED TABLESPACE' privilege.
i have given connect , resource privilege to u1.
SQL> create user u1 identified by u1;
User created.
SQL> grant connect , resource to u1;
Grant succeeded.
SQL> select * from dba_sys_privs where grantee='CONNECT';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
CONNECT CREATE SESSION NO
SQL> select * from dba_sys_privs where grantee='RESOURCE';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
RESOURCE CREATE TRIGGER NO
RESOURCE CREATE SEQUENCE NO
RESOURCE CREATE TYPE NO
RESOURCE CREATE PROCEDURE NO
RESOURCE CREATE CLUSTER NO
RESOURCE CREATE OPERATOR NO
RESOURCE CREATE INDEXTYPE NO
RESOURCE CREATE TABLE NO
8 rows selected.
Here , how user u1 has UNLIMITED TABLESPACE privilege ?
SQL> select * from dba_sys_privs where grantee='U1';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
U1 UNLIMITED TABLESPACE NO
Thanks