Anti-Rich
Well-known member
Hi all,
i have just developed an application that will be outputting statistics on warehouse picks (ie. people coming and picking up stores). now, i need this application to be run on several computers, and i want to set up relevant roles/users (whichever one it is!). one for admins, and one for data entry people. now i have been using MS SQL Management express to try and set up a login, and then a user in the database for that login, and then i add the tables, grant select update insert delete permissions where necessary. the only problem is, it doesnt save the permissions!!! i have been tweaking around with various things, only to keep hitting that same brick wall. can someone please explain how to set up these permissions properly (with a username and password), and explain where im going wrong.
much appreciated
regards
adam
i have just developed an application that will be outputting statistics on warehouse picks (ie. people coming and picking up stores). now, i need this application to be run on several computers, and i want to set up relevant roles/users (whichever one it is!). one for admins, and one for data entry people. now i have been using MS SQL Management express to try and set up a login, and then a user in the database for that login, and then i add the tables, grant select update insert delete permissions where necessary. the only problem is, it doesnt save the permissions!!! i have been tweaking around with various things, only to keep hitting that same brick wall. can someone please explain how to set up these permissions properly (with a username and password), and explain where im going wrong.
much appreciated
regards
adam
