Re: ORACLE ROLES - Reg

If you do not give a quota to this user on the tablespace, it will asume a quota of zero. The user will therefore not be able to allocate extents within the tablespace unless it has UNLIMITED TABLESPACE privilage.

Regards....Simon

ctkumar <ctkumar_at_pacific.net.sg> wrote in article <32A51AD2.4118_at_pacific.net.sg>...
> 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 ]
>
Received on Wed Dec 04 1996 - 00:00:00 CET