| Run the SQL query: |
select distinct o.owner from dba_objects o, dba_users u
where o.owner not in
and o.object_type <> 'SYNONYM'
and o.owner = username
and upper(account_status) not like '%LOCKED%';
(With respect to the list of special accounts that are excluded from this requirement, it is expected that the DBA will maintain the list to suit local circumstances, adding special accounts as necessary and removing any that are not supposed to be in use in the Oracle deployment that is under review.)
To obtain a list of users assigned DBA privileges, run the query:
select grantee from dba_role_privs where granted_role = 'DBA';
If any records are returned, then verify the account is an authorized application object owner account or a default account installed to support an Oracle product.
Verify that any objects owned by custom DBA accounts are for the personal use of that DBA.
If any objects are used to support applications or any functions other than DBA functions, this is a finding.
Any unauthorized object owner accounts are not a finding under this check as they are noted as findings under check O121-C2-011000.
Any other accounts listed are a finding.