Create sql server users and groups using SQL statement

[miceisland]

Halo, Which tables in SQL server i need to update to create users for database and assign them to a groups? any articles to share. planning to use this sql script from vb.net to create users ;) thanks Stephen --------------------- www.islasolutions.net

[Colin Angus Mackay]

miceisland wrote:

Which tables in SQL server i need to update to create users for database and assign them to a groups?

You don't update any tables. You should use the stored procedures: * sp_grantdbaccess[^] * sp_addrolemember[^]

---

"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

[miceisland]

many thanks. i will try this. :-D --------------------- www.islasolutions.net

[Eric Dahlvang]

Also see: sp_addlogin[^] ---------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters