ALTER USER

Alter User Default Temporary Tablespace Examples

by Ed Chen
August 29, 2022September 12, 2022

Default Temporary Tablespace Normally, all users in the database use the same default temporary tablespace except that we specifically set another one for them. In… Read More »

Alter User Default Tablespace Examples

by Ed Chen
August 26, 2022September 12, 2022

Default Tablespace The default tablespace in the database for all users is USERS if you didn't specify the default one for the user. This can… Read More »

Revoke Quota Unlimited on Tablespace from User

by Ed Chen
July 10, 2022October 2, 2022

Revoke Tablespace Quota In previous post, we have talked about how to set quota on tablespace for users. Now, let's see how to revert it.… Read More »

Grant Quota on Tablespace to User

by Ed Chen
July 10, 2022September 29, 2022

Grant Tablespace Quota Since quota usage limitation is not an object privilege, we can't grant it like this: SQL> grant quota 100g on erpapp_tbs_01 to… Read More »

How to Resolve ORA-28002: the password will expire within days

by Ed Chen
February 1, 2020February 28, 2022
2 Comments

ORA-28002 ORA-28002 means that the password of the user will expire soon in X days, although the user is allowable to connect to the database.… Read More »