Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Column Level Permissions

By Mani Singh,

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.

Total article views: 1774 | Views in the last 30 days: 2
 
Tags
administration    
columns    
permissions    
t-sql    
 
Contribute