|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/11/2006 10:19:00 PM
Posts: 2,
Visits: 1
|
|
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.
|
|
|
|