ITPUB

Jun 19, 2016 · Databases

Why Oracle User Can Create Tables in Unauthorized Tablespaces

The article explains how a newly created Oracle user with the RESOURCE role inherits the UNLIMITED TABLESPACE privilege, allowing table creation in any tablespace, and how the 11gR2 deferred segment creation feature creates the illusion of permission, while providing methods to disable it globally or per‑session to enforce true tablespace restrictions.