Sample Application System Design

The sample application developed in this book is called The Ultimate Human Resources Application (TUHRA) (pronounced “too-rah”). As discussed in the Introduction, this application uses the database objects installed in the HR schema in Oracle9i and Oracle 10g. The purpose of the application is to allow access to and modification of the data in the HR tables. The Security Administrator for the company assigns one of three application roles—user, admin, and manager—to each user by entering the user and role in a security file (described in Chapter 14).

Users assigned the user role are allowed to search for any employee record, but will not be able to edit any employee record but their own. Users assigned the manager ...

Get Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.