lundi 30 mai 2016

Column level entitlement implementation by Design pattern

I want to implement column level entitlement by using design patterns. In our application will have to restrict user to query specific column only.

for example.

Table : employee

id number(10,0), fname varchar2(100), lname varchar2(100), address varchar2(100), age number(10,0),


Users: U1,U2

I want to give access/entitlement of [id,fname,age] columns to user U1 and [id,lname,address] columns to user U2.

which design patter i will use to implement it.

Aucun commentaire:

Enregistrer un commentaire