Re: ORACLE ROLES - Reg

ctkumar wrote:
> 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.

  The default tablespace quota is zero. So the user cannot create a table on the USERS tablespace. If you assign a profile to the user, check the setting of the profile. If you do not assign a profile to the user, check the setting of DEFAULT profile.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841