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.