Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java

Working as the Security Administrator

Now that our security administrator has been defined with the privileges he needs to do his job, we are going to put him to work. Go ahead and connect:

CONNECT secadm;

Note You can find a script of the following commands in the file named Chapter2/SecAdm.sql.

As you will recall from our creation of the security administrator role, secadm_role, we required that it be validated by a procedure. We have only permitted one account, secadm to execute the procedure. Execute it now to acquire secadm_role:

EXEC sys.p_check_secadm_access;

Note that when secadm connects to Oracle, he does not automatically acquire ...