Setting Application Context in Oracle for RLS
Posted on 2011-09-15
I have a requirement.
I have web Based Oracle Application (Oracle Forms 10gAs and Oracle 10g DB).
There are approx. 800 application userid but only one DB User .
All application userid is maintained in a table (say T_USER_MASTER).
Each application Userids is associated with one user role or more (stored in T_USER_ROLE).
I want to restrict one column(Col1) of a table (say T1) for all application userid other than one who is doctor (Role).
I want to do this through RLS but I do not know where ,when & how to set system context for this.
Pls.let me know the steps to be followed.