Security Administrator Activities
Our security administrator, secadm, needs to provide a few more permissions. Some of the permissions are system privileges, and some are grants to packages in the appsec and HR schemas.
Note You can find a script of the following commands in the file named Chapter7/SecAdm.sql.
Connect to Oracle database as SECADM user, and acquire the secure application role, secadm_role.
EXECUTE sys.p_check_secadm_access;
We are going to be creating a table in the appsec schema for logging errors. We are also going to create a trigger associated with that table. Our trigger is like a procedure that runs when certain events ...
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.
