UCF STIG Viewer Logo

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


Overview

Finding ID Version Rule ID IA Controls Severity
V-3847 DO0157-ORACLE11 SV-24501r2_rule Low
Description
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.
STIG Date
Oracle Database 11g Instance STIG 2017-06-29

Details

Check Text ( C-29415r2_chk )
From SQL*Plus:

select username, tablespace_name from dba_ts_quotas
where username not in (select distinct owner from dba_objects)
and username not in
(select grantee from dba_role_privs where granted_role='DBA');

Review the list of user names returned.

If any belong to application users or application administrators, this is a Finding.
Fix Text (F-26442r1_fix)
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.