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.....