User able to create tables without quota
How come PATEST user is able to create table in his own tablespace , even in another tablespace when no quota is defined for it?
DBA_USER prod_padw >create user patest identified by Temp1234 default tablespace users temporary tablespace temp ;
User created.
DBA_USER prod_padw >grant Create session, Create table, Create procedure, Create sequence, Create synonym to patest;
Grant succeeded.
DBA_USER prod_padw >
DBA_USER prod_padw >conn patest/Temp1234@prod_padw
Connected.
PATEST prod_padw >create table test (name varchar2(100));
Table created.
PATEST prod_padw >create table test1 (name varchar2(100)) tablespace PA_DATA01;
Table created.
PATEST prod_padw >select tablespace_name, table_name from user_tables;