Is it possible to assign SQL Server column level security directly to a table without using a view?
Say, for example, for the table 'tbl', if I want column 1 to be restricted for user 1, is it possible for the user to query a select * from tbl with the output being a column out of two except the restricted columns ???
From what I understand, this is not possible and would cause an error indicating that a column is restricted.
I would be there in another way ????