O'Reilly logo

Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java by David Coffin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Application Security User Activities

We are going to create an error log table, and an insert trigger, and we will also be adding procedures to do logging to app_sec_pkg package.

images Note You can find a script of the following commands in the file named Chapter7/AppSec.sql.

Connect to Oracle database as appsec user, and set your role to the non-default role, appsec_role:

SET ROLE appsec_role;

Creating a Table for Error Logging

Next, create a table for error logging. Probably, you want to pull out your DBA skills or get a DBA to help you define this table, setting its performance parameters and estimating initial storage and growth plans, none ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required