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