O'Reilly logo

Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java by David Coffin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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;

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required