RE: how to prevent user access from outside of a third-partyapplication
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Nov 2004 09:27:52 -0600
Perhaps you can check the program column of V$SESSION in a logon =
trigger?
Rich
-----Original Message-----
Sent: Tuesday, November 02, 2004 7:24 AM
To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx;
Subject: how to prevent user access from outside of a
third-partyapplication
Since I can not disable a role through a logon database trigger, I am
seeking help in how to prevent a user from updating tables outside of
the third-party application. The user is granted a role which permits
update. I can not password protect the role since it is used by the
third party application. What are some options. Fine grained access
control is not realistic since would have to set it up on every table in
the system.
=20
=20
=20
Jeffrey Beckstrom
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: how to prevent user access from outside of a third-partyapplication
