Example output from Dbvice

[Mike Donovan]

The Dbvice audit results will be shown on screen and can also be written to a file as a report.

Below is an example of output produced from running Dbvice on a Windows server:

==============================
Dbvice output started: Tue Oct 20 17:00:50 2009
==============================
Database: w111g

Results for the Default Passwords Check
==============================
No users have their default password set


Results for the Listener Security Check
==============================

The Listener is not running
Listener parameter ADMIN_RESTRICTIONS_LISTENER could not be tested as listener is down


Results for the User Privileges Check
==============================
The following privileges have been granted to these users and may need further investigation to determine
if they are actually required:

Username: ORACLE_OCM
Granted Direct Privileges: SELECT ANY DICTIONARY

Username: SPATIAL_CSW_ADMIN_USR
Granted Roles: CONNECT,RESOURCE,SPATIAL_CSW_ADMIN
Granted Direct Privileges: ALTER ANY ROLE,DROP ANY ROLE,CREATE ANY DIRECTORY,UNLIMITED TABLESPACE,GRANT ANY ROLE

Username: MDDATA
Granted Roles: CONNECT,RESOURCE
Granted Direct Privileges: UNLIMITED TABLESPACE

Username: SPATIAL_WFS_ADMIN_USR
Granted Roles: CONNECT,RESOURCE,SPATIAL_WFS_ADMIN
Granted Direct Privileges: CREATE ANY DIRECTORY,GRANT ANY ROLE,ALTER ANY ROLE,DROP ANY ROLE,UNLIMITED TABLESPACE

Username: TSMSYS
Granted Roles: RESOURCE
Granted Direct Privileges: UNLIMITED TABLESPACE

Username: OWBSYS
Granted Roles: AQ_ADMINISTRATOR_ROLE,AQ_USER_ROLE,CONNECT,CWM_USE R,JAVAUSERPRIV,JAVA_ADMIN,OLAP_USER,OWB$CLIENT,OWB _DESIGNCENTER_VIEW,OWB_USER
Granted Direct Privileges: CREATE ANY CONTEXT,ALTER SESSION,ALTER USER,DROP ANY DIRECTORY,UNLIMITED TABLESPACE,CREATE ANY DIRECTORY,DROP PUBLIC SYNONYM
Granted Indirect Privileges: DEQUEUE ANY QUEUE,ENQUEUE ANY QUEUE,MANAGE ANY QUEUE,ALTER SESSION

Username: FLOWS_030000
Granted Roles: CONNECT,RESOURCE,SELECT_CATALOG_ROLE,HS_ADMIN_ROLE
Granted Direct Privileges: CREATE ANY CONTEXT,ALTER DATABASE,DROP USER,DROP TABLESPACE,EXECUTE ANY PROCEDURE,SELECT ANY TABLE,UNLIMITED TABLESPACE,ALTER USER,ALTER SYSTEM,DROP PUBLIC SYNONYM,ALTER SESSION



Results for the Database Options Check
============================
A list of the options installed in the Database:

Objects
Connection multiplexing
Connection pooling
Database queuing
Incremental backup and recovery
Instead-of triggers
Parallel load
Proxy authentication/authorization
Plan Stability
Coalesce Index
Transparent Application Failover
Sample Scan
Java
OLAP Window Functions


Results for the Sample Schema Check
===============================
A list of sample schemas installed in the Database:

SCOTT

Results for the Remote Auth Check
===============================

The REMOTE_OS_AUTH parameter is set to false


Results for the File Permissions Check
===============================
The following is a list of files with file-system permissions that may need further investigation:

Test not performed on Windows.


Results for the Public Privileges Check
===============================
PUBLIC can EXECUTE the following packages:

UTL_TCP, UTL_HTTP, UTL_FILE, UTL_SMTP

===============================
Dbvice output completed.
===============================