QUOTA Problem

Hi,
I have a problem here. I have an USER suppose "A". I want to restrict that user from creating any objects in SYSTEM tablespace.

How do I do this. I have tried

alter user A quota 0 on SYSTEM;

alter system set resource_limit = true;

But still that user is able to create tables in SYSTEM tablespace and populate rows. Please help me out.....


Thanks

Amit

Perhaps the user's default tablespace and temporary tablespace are set to SYSTEM.

1. Log in as DBA
2. Determine the default and temporary tablespaces for
the user from the DBA_USERS view

3. If set to SYSTEM,

ALTER USER joe default tablespace USERS;
ALTER USER joe temporary tablespace TEMP;

Good luck.

Check your user's system privileges: I'm sure your user has been granted UNLIMITED TABLESPACE privilege, that is why setting his quota on SYSTEM to 0 has had no effect.

Isue "REVOKE UNLIMITED TABLESPACE FROM A;" and check if he is still able to create objects in SYSTEM tablespace.