Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"UNLIMITED TABLESPACE" is revoked - don't know who did that

91049Jun 5 2007 — edited Dec 20 2007

I got call from developer they encountered error from insert statement stating

ERROR at line 1:
ORA-01536: space quota exceeded for tablespace 'XXXXXXXX'

I went there and found that "unlimited tablespace" is revoked from that user.

I can not explain how it happened since I am the only DBA for this database. Although one of the developers has DBA privilege, I don't think he has the ability to do so. There is no reason for anybody to do so.

The database is 9.2.0.7 with 2nd Quarter CPU patch.

My question is that is there any other mechanism to make this happen? This is really strange to me.

jzc

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2008

Added on Jun 5 2007

#general-database-discussions

11 comments

11,704 views