How to create sql server database user and assign it to a group?

[miceisland]

hi, :confused: i need to create a asp.net using vb.net program to manage sql server database users and groups, can someone advice the best way to do this, i was thinking of using sql queries to do this, but dont know where to start :^) ? is there other best way to this, or can give me links to article concerning this? many many thanks guys! regards, :cool: Stephen --------------------- www.islasolutions.net

[Colin Angus Mackay]

miceisland wrote:

i was thinking of using sql queries to do this, but dont know where to start?

I usually start by working out what the application needs to do. I create a list of functions it performs. If there is a technology that I need to use that I don't know much about then I read articles about it, look at samples and build small test riggs to demonstrate to myself how it works.

miceisland wrote:

or can give me links to article concerning this?

You can use your favourite search engine to look for "SQL Server" and "user", "group", "role", "login", etc. Once you have some idea of what you can do and you have a specific query (rather than this vague query) then forums become a great place to get the answers to your questions. At the moment any answer can only be as vague as the question.

---

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog