Filter Tables According to User

hi,

im new sql server , im having trouble decide wich best way filter tables 1 user can read , write.

for example table sales field named branch (smallint) values 1 or 2 (the store made sale). user "a" can see , write records branch = 1.

im developing windows program shows purchased orders in datagridview. should make filters (permissions) in program or in sql server?.

i hope made self clear (my english not good)

you can use views restrict user's access data in table. views can function filters , users should granted no access base table, views corresponding access level.

implementing kind of row level security can attempted in various ways. here's whitepaper describes more elaborate solution:

http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

if search web "sql server row level security" should able dig more third party papers on topic.

thanks
laurentiu

SQL Server  >  SQL Server Security