ORA-01950: no privileges on tablespace ‘X’


A user called JIM has left your organisation, you have revoked their roles to the database, 4 days later during a restart of your application, some people start reporting ‘ORA-01950: no privileges on tablespace ‘ORA-01950: no privileges on tablespace X’, whats happened.

You have checked the owners being used in the application, and tried to insert into the table a row using the user.

They all have the roles that have permissions to the table space. They have unlimited quotas

Lets look deeper to the schema

We revoked JIM’s access when he left but he still has objects in the application schema.

For sure if new extents are going to be allocated for this object, it will fail with the no privilege error. It may still work for some users because the already allocated extent space for JIM can be used without any issues.