We are going to create an error log table, and an insert trigger, and we will also be adding procedures to do logging to
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,
SET ROLE appsec_role;
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 ...