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 ...

Get Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java now with O’Reilly online learning.

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