Hi all,
I have given the scenarios with result.
create user user1 identified by pwd
quota 10m on user(TS)
quota 0 on system;
conn user1/pwd;
I created table by name emp
create table emp(eno number)
tablespace user;
I inserted few values into emp table.
Later I altered the user using
alter user user1 quota 0 on user ;
But still its allowing me to insert data into emp.
If i am correct means it should not allow user1 to insert bcz i ve made quota 0 on both user and system TS.
It is also allowing user1 to create few more databse objects in user1 schema.
Let me know whether it should allow to insert or not on emp and to objects in user1 schema.
Regards,
Chaitra