I have an instance of Oracle 11g created manually with only data dictionnary creation scripts executed.
When I create a user the later seems to have unlimited tablespace everywhere even though I did not gave any quota on any tablespace.
The user only have granted the "create session" and "create table" privileges.
If I try to revoke "unlimited tablespace" I get a message stating that the user does not have this privilege.
What do I miss to enforce quota limitation on this instance cause clearly it is not?
Thanks for your insights.