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	ECLP-1	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	2015-03-26

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.

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.