DO0157-ORACLE11 - Database application user accounts should be denied storage usage for object creation within the database.

Information

Tablespace storage quotas allow limits on storage use to be assigned to Oracle database users. Although this does not grant the user the privilege to create objects within the database, it provides an additional method to restrict unauthorized object creation and ownership.

Solution

Assign tablespace quotas only to database accounts authorized to create and or own objects in the database.

Document authorized tablespace quotas for all accounts authorized to own objects in the System Security Plan.

Remove any quotas assigned to application users, application administrators, or any other unauthorized accounts.

From SQL*Plus:

alter user [username] quota 0 on [tablespace name];

Replace [username] with the named user and [tablespace name] with the identified tablespace name.

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_Oracle_Database_11g_Y21M10_STIG.zip

Item Details

Category: SYSTEM AND COMMUNICATIONS PROTECTION

References: 800-53|SC-6, CAT|III, Rule-ID|SV-24501r2_rule, STIG-ID|DO0157-ORACLE11, Vuln-ID|V-3847

Plugin: OracleDB

Control ID: 7783b8d0b7fb9ffb9261662367528327aa1123a2bba641e4ed51b449604113c9