Originally posted by slimdave i believe that the role granted unlimited tablespace to the user -- revoking it removed that privilege, but the user probably left tables in a TS they then had no quota on
OK.. but does revoke change the quota of existing users on TS?
If so what may be the correct approach to revoke the DBA role under such circumstances?
hmm, Try granting him DBA role again and see if he gets this error. If he still gets Tablespace Quota Error, then it has got nothing to do with revoke. Check if he is accessing the right Tablespace, default tablespace, Quota, etc. In short, Assign proper Tablespace and required Quota to the User.