p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Pro VB Databases (http://p2p.wrox.com/forumdisplay.php?f=81)
-   -   Create SQL Server user programmatically? (http://p2p.wrox.com/showthread.php?t=35934)

Dmitriy December 8th, 2005 02:08 PM

Create SQL Server user programmatically?
 
Hello,
I have a question for everybody:
How to create SQL Server's database user programmatically and how to assign the role (or permission level) for new or an existing user?
Any code examples or referrals will be gladly appreciated.
Thanks in advance,
   -Dmitriy[V]



peko March 8th, 2006 10:02 AM

Use StoredProcedures sp_addlogin, sp_adduser, sp_addrolemember
via ADO.Command

Peko



All times are GMT -4. The time now is 10:00 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.