Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
janus006
Starting Member
4 Posts |
 Posted - 2010-05-15 : 16:59:48
|
| I'm new to this wonderful forum.I'm developping a VB6.0 application that accesses data of sql server2000. I made a successful linking with recordset and so on, I use sql queries through VB6.0 with no problem. Now I got 5 users for the application, the boss and the 4 crew members.I want the boss, to see and do everything he wants.a crew can see only his data, not his fellow's data unless he is authorized by the boss(prior) or by the meant fellow.I think about creating a users table, and link users' table to all the tables and add 'and where user= joe' whenever I want data for joe.but I want to see if isn't there any other elegant solution, within sql server and using standard sql server users that are in the data bases.says the newbie |
|
|
|
|
|
Data and users