Working as the HR Schema User
For several aspects of the endeavors put forth in this book, we are going to use the HR sample schema that can be installed with Oracle 11g. If you haven't got that schema installed, you will have had difficulties in the preceding step that configured auditing on HR schema structures. Please browse to the Oracle web site for instructions on how to install the sample schemas after the fact.
Now, at the installation of Oracle, you also had the opportunity to configure a password for the HR user. If the sample schemas exist but the HR user is not configured (or simply to reconfigure the user), you can issue the ALTER USER command (as SYS or secadm):
ALTER USER hr ACCOUNT UNLOCK IDENTIFIED BY password;
Caution Be ...
Get Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
