The Oracle WITH GRANT OPTION privilege should not be granted to non-DBA or non-Application administrator user accounts.

Changes are coming to https://stigviewer.com. Take our survey to help us understand your usage and how we can better serve you in the future.
Take Survey

The Oracle WITH GRANT OPTION privilege should not be granted to non-DBA or non-Application administrator user accounts.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-2533	DO3451-ORACLE11	SV-24905r3_rule		Medium

Description
An account permission to grant privileges within the database is an administrative function. Minimizing the number and privileges of administrative accounts reduces the chances of privileged account exploitation. Application user accounts should never require WITH GRANT OPTION privileges since, by definition, they require only privileges to execute procedures or view / edit data.

STIG	Date
Oracle Database 11g Instance STIG	2017-06-29

Details

Check Text ( C-29463r3_chk )
Execute the query: select grantee\|\|': '\|\|owner\|\|'.'\|\|table_name from dba_tab_privs where grantable = 'YES' and grantee not in (select distinct owner from dba_objects) and grantee not in (select grantee from dba_role_privs where granted_role = 'DBA') order by grantee; If any accounts are listed, this is a finding.

Fix Text (F-26525r1_fix)
Revoke privileges granted the WITH GRANT OPTION from non-DBA and accounts that do not own application objects. Re-grant privileges without specifying WITH GRANT OPTION.