Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
acko
Yak Posting Veteran
52 Posts |
 Posted - 2003-08-04 : 10:20:20
|
| HiCan anyone help me to make sql user from vb6I've done this Dim cmd As ADODB.Command Set cmd = New ADODB.Command With cmd .ActiveConnection = CN .CommandType = adCmdStoredProc .CommandText = "sp_addlogin" .Parameters(1) = "Name" .Parameters(2) = "password" .Parameters(3) = "DB" .Execute End WithBut user which is created can't access the DB database.How can i manage permission from vbThanksAlex |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-08-04 : 10:36:29
|
| After you have created the login with sp_addlogin, you will have to give the user access to the database by executing sp_adduser. |
 |
|
|
|
|
|
Sql User From VB