Column Level Permissions

,

This Code is used to Grant column level permissions to Specific USers.

Again, another approach is to Create a View based on the table and capture only those certain columns required by a certain set of users. and give those users the access to the view Or use the view in the application insted of the table.

Infact you can create seprate views for users and Admins from the same Table, according to priviliges.

EG: Username/Domainname is [MyDOMAIN\Mani]

GRANT SELECT (<column1>, <Column2>,<Column3>) ON Employees TO [MyDOMAIN\Mani]

DENY SELECT <Column1> ON Employees TO [MyDOMAIN\Mani]
-- DENY SELECT on column1

Rate

2.2 (5)

Share

Share

Rate

2.2 (5)