Re: ORACLE ROLES - Reg

Hi Kumar,
I think you have to give unlimited
tablespace to the user if you do not
want to have any space restrictions
on the user.
  Kittu.

ctkumar (ctkumar_at_pacific.net.sg) wrote:
: 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