ORA-01950: no privileges on tablespace ‘X’

Problem: 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.
Posted in Blog Tagged with: ,

Affiliations

Engagements

  • Oracle OpenWorld 2014
  • Gartner BI Summit 9/3/15-10/3/15
  • UKOUG Business Analytics SIG 12/3/15
  • UKOUG Conference 7/12/15-9/12/15
  • Oracle Ireland Conference 2016 3/3/16-4/3/16
  • UKOUG Systems 2016 12/5/16
  • Oracle OpenWorld 2016
  • POUG 2016 7/10/16
  • DOAG 2016 15/11/16
  • UKOUG 2016 5/12/16

Videos

Posts

  • 2017 (8)
  • 2016 (22)
  • 2015 (22)
  • 2014 (8)
  • 2013 (2)