Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Secure Application Role

8 views
Skip to first unread message

Joseph

unread,
May 16, 2012, 9:49:46 AM5/16/12
to
Hi,

I'm in the process of eliminating Password-Protected Role with Secure
Application Role. I understood how to define a Secure Application
Role, and how to apply it to a user by executing the 'IDENTIFIED
USING' procedure.

I like to know how exactly to use Secure Application Context for the
same. Mainly I want to know how to securely restrict Oracle database
users to connect only through application.

TIA.

John Hurley

unread,
May 16, 2012, 9:22:44 PM5/16/12
to
Joseph:

# Mainly I want to know how to securely restrict Oracle database users
to connect only through application.

You can use an after logon database trigger and look at each new
( about to be ) session and see what program etc is involved ...
reject anything that does not cut mustard.

0 new messages