1.3 Ensure All Sample Data And Users Have Been Removed

Information

The sample data is typically not required for production operations of the database and provides users with well-known default passwords, particular views, and procedures/functions. Such users, views, and/or procedures/functions could be used to launch exploits against production environments.

Solution

To remediate this setting, it is recommended that you execute the following SQL script. $ORACLE_HOME/demo/schema/drop_sch.sql NOTE: The recyclebin is not set to OFF within the default drop script, which means that the data will still be present in your environment until the recyclebin is emptied. Impact: The Oracle sample user names may be in use on a production basis. It is important that you first verify that BI, HR, IX, OE, PM, SCOTT, and/or SH are not valid production user names before executing the dropping SQL scripts. This may be particularly true with the HR and BI users. If any of these users are present, it is important to be cautious and confirm the schemas present are, in fact, Oracle sample schemas and not production schemas being relied upon by business operations.

See Also

https://workbench.cisecurity.org/files/601