ORACLE ROLES - Reg

Hi there,

I encountered a problem while granting roles to the users. The problem is
 I created a role called 'DEVELOP' and gave privileges like CREATE CLUSTER, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER (All the above privileges are as in RESOURCE ROLE), ANALYZE ANY etc to this role. After Creating this ROLE, I created a user called "TEST" under 'DEVELOP' Role. This user has CONNECT and DEVELOP Role with normal access to tablespace 'USERS'. But when I logged in as TEST and tried to create a table, ORACLE displayed an error message 'ORA-01536: space quota exceeded for tablespace 'USERS''. Note, I have not given any quota restrication.

to this user. Is there anybody who can advise on this problem.     

-- 
Kumar Chidambaram              [ Pacific Internet Pte Ltd
Database System Analyst          89 Science Park Drive #04-09/12
                                 The Rutherford, Singapore 118261
                                 Tel : (65) 771 0860
                                 Fax : (65) 773 6812 ]