How Does user have unlimited tablespace privilege?

Hello.

I create my users in the following manner:

create user user_name1 identified by user_name1 default tablespace users temporary tablespace temp quota 0 on system quota unlimited on users
;

grant resource, connect to user_name1
;

The user then has the system privilege unlimited tablespace. If I do not revoke this privilege, any dump for the user (from another database) is put into the system tablespace. No, the user I get the dump from does not have ANY objects in system. The user I get the dump from has a tablespace default set to users as well, along with quota 0 on system.

Why is the dump put into the system tablespace? Received on Mon Jun 12 2000 - 16:30:24 CDT