I am sure I should either know this or have been able to determine this, but I am investigating an issue with user allocated space quotas and am wondering how to determine the default (if there is one).

Our users are running into a problem with a database set up by another individual and apparently none of them were set up with specific quotas. Is there some default quota that users are set to and if so, how can I determine what that is or change it. At this point, I am setting them individually, but was not sure why they were never established originally.

1 Answer 1


Tablespace Quotas for a User


By default, a user has no quota on any tablespace in the database.


  • Appreciated. I have generally assigned a quota in the past. Is it common to not assign any and what benefits are derived by doing that?
    – FocusWiz
    Aug 21, 2018 at 13:13
  • @FocusWiz Quotas should be used to control the amount of data a user can store in the database. The benefits of not assigning a quota are the same as not granting unnecessary privileges. However the most common reason I see for not assigning quotas is laziness/ignorance. Software vendors deliver their products with instructions in which they just simply grant the UNLIMITED TABLESPACE system privilege to users, which renders tablespace quotas meaningless. Aug 21, 2018 at 13:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.