Dynamic row level security implementation ...

UDA

Dynamic row level security implementation ...

I have created a view common to department A and B,

REPLACE VIEW DEPT_EMP select NAME, POST, ADDR1, DEPT CD
from EMPLOYEE;

NAME, POST, ADDR1, DEPT CD
TEST1 ABC TEST A
TEST1 ABC TEST B

when the user from department A login and query DEPT_EMP he should get only his record "TEST1 ABC TEST A"

when the user from department B login and query DEPT_EMP he should get only his record "TEST1 ABC TEST B"

Do any one know how to implement this security using control table.