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?