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-ORACLE10	SV-24500r1_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 10 Database Instance STIG	2014-01-14

Details

Check Text ( None )
None

Fix Text (F-26441r1_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-26441r1_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.