Quota exceeded ?

From: astalavista <spam_at_nowhere.com>
Date: Tue, 28 Jun 2005 21:16:57 +0200
Message-ID: <42c1a12d$0$17123$636a15ce@news.free.fr>

Hi,

Something weird with a user
He connects with sqlplus , he has the following error:

ERROR:

ORA-00604: error occurred at recursive SQL level 1
ORA-01536: space quota exceeded for tablespace 'DATA_TMP'
ORA-06512: at line 28

He has quota unlimited on this tablespace

His privileges are:
create session
create table
create trigger
create view
unlimited tablespace

If I grant DBA role to the user
the connection is OK

The only thing (for him ) he done, is change his password before the connection was OK.

Can you explain that ???

Thanks in advance

Oracle 9.2.0.1
AIX 5.1 Received on Tue Jun 28 2005 - 14:16:57 CDT