astalavista wrote:
> 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
>
Someone revoked unlimited tablespace *after* granting
quota? Re-issue the quota statement (thought that was
fixed by now? Used to err in 8i...)
--
Regards,
Frank van Bortel
Received on Tue Jun 28 2005 - 14:49:57 CDT
