Organization of the Next Few Sections

I want to make the process of working through this material as easy as possible for you. Toward that end, I have separated into sections the tasks and concerns of each of three users: SYS (the database administrator), the security administrator that we will be creating here, and the HR (human resource) schema owner.

For the most part, SYS as the database administrator could do all these tasks, but it is my intent to demonstrate security with delegation. We will have each of these users accomplish the tasks that are specific to their delegated responsibility. The commands to be executed by each of these users are consolidated into a single script file per user, and it is possible for us to focus on tasks and ...

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.