Oracle Structures for Secret Password Encryption

In the last chapter, we created an Oracle function and a procedure to demonstrate use of our RSA public key encryption in a client/server environment. Now we will create an Oracle package with multiple functions and procedures, including Java stored procedures, to handle our secret password encryption.

The package will be placed in the Application Security, appsec schema. As the appsec user, first set your role to the non-default role, appsec_role with this command:

SET ROLE appsec_role;

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

As you read through ...

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.