Column Level Security

[enigma333]

Is there anyway to use column level security but instead of an error when attempting to select a column with no permission I want to have it just not appear.
i.e. Give access to 3 of 5 columns then when you do a SELECT * FROM TABLE you get just those 3 columns
Any thoughts.
Thanks

 

[RickCole]

Create a view on the table and then give the users just permissions to the view for example:

CREATE VIEW viewename AS
SELECT col1, col2, col3
FROM tablename


Rick.

 

[enigma333]

Wanted a different way that would require fewer views .. a lot of different users to maintain so views will become tedious