I have a problem. I would like to restrict showing specific users (or roles or schemas) data in a column. First I thought DENY option will do it but figured out that it won't. DENY denies the column being in the SELECT query. I would still like to call the
column but if access to the data in that column is restricted it would show only null values and not the real ones.
So... I would like call the next query from user TestUser:
But if access to Address is restricted for TestUser I would get results like:
1 John Smith
2 Rick Ross
Is it possible to do something like that in SQL Server 2005/2008? I was thinking of storing that kind of information in a table (for which tables, which columns for which users access is restricted) and then manipulate it on the application site but my programmers
tell me that they use components which always call the full table (like SELECT *).
Thank you for your answer.
View Complete Post