vpd in oracle applications environments

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Mon, 2 Mar 2009 04:55:21 -0800
Message-ID: <a2b1e7610903020455w3bb62ee8oc224b7bbcc6336fd_at_mail.gmail.com>

Hi All:
Could you share your experiences in implementing vpd in an oracle applications environment?
For example if I want to create a policy like this where apps user can view SSN of any user but named sql accounts shoud be able to view only thier ssn, then each time I execute select national_identifier from per_all_people_f as apps user then I would get all the national_identifiers for all users. But because of this policy that is defined would it add an over head and cause performance issues because oracle applications uses internally apps (when logged in through forms) and if it appends the predicates to teh different policies, it may create an additoinal overhead. Is this significant ?

Thank you for your inputs.

  • Kumar
Received on Mon Mar 02 2009 - 06:55:21 CST

Original text of this message