hello every 1 i am new to this forum i am having a lot of difficulty in giving privileges to login user. i am using vb.net and sql server 2008. What i want to do is i want to create an admin account . Admin will have all access on windows form. Than i want to register employees but employees going to have some privileges on viewing forms and option. i just dont know where to set these privilege. Is it going to be in sql server. Or how am i going to determine the new registered member is an admin or employee.Please reply any 1 i m in big need to this answer. i will be gratefull if you can answer step by step.
Jump to Post
There are a couple of approaches. What I did at work depended on the application(s). If an application needed access to just one database then I would create two accounts in SQL server named APP_RO and APP_RW, where "APP" was replaced with the application name, and RO and RW denoted …
All 3 Replies
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.