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
How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?
2009-10-30 (first published: 2008-08-05)
32,517 reads
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
2008-07-28
21,648 reads
Searches for actual and potential foreign key columns for a given primary key reference.
2009-10-12 (first published: 2008-06-20)
2,494 reads
2008-08-08 (first published: 2008-06-16)
919 reads
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,624 reads
