It is the share available to the user to create objects in the Tablespaces and without it the user is unable to create any object.

Therefore, the database administrator can prevent the user from creating any object by granting him an unlimited Quota in the Tablespace by granting him Unlimited.

The share can also be granted to the user during creation or after that.

Now let's assume that we want to give zero share to user TEST in the Users Tablespace.

ALTER USER TEST QUOTA 0M ON USERS;

Now let's assume that we want to give him unlimited access to the Users Tablespace.

ALTER USER TEST QUOTA UNLIMITED ON USERS;

Another option is to grant this user an authority called Unlimited Tablespace, which allows this user an unlimited share of Tablespaces.

GRANT UNLIMITED TABLESPACE TO TEST; 

As we mentioned earlier, the share can be granted during user creation as follows:

CREATE USER TEST IDENTIFIED BY TEST QUOTA 2M ON USERS; 

You can inquire about the share through:

DBA_TS_QUOTAS

USER_TS_QUOTAS