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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-25 : 06:56:19
|
| sheen writes "hie,my comp has windows XP and i have this problem:i know how to create users and login in a database, i.e using enterprise manager ,by GUI tools provided, but i dont know how to by querying..in microsoft SQL 7.0 ,what is the query to create a new user as well as grant him a connection privilegealso i will be using this query in either vb6.0 or asp3.0 to create users dynamically !!the solution to this problem will be a great help!!thanx" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-25 : 07:16:38
|
| Creating users via an application is usually a bad idea.Look at sp_adlogin, sp_adduser - the application will need to connect with the privileges to do this or use the agent to run it as sa.Also think about using roles and adding the user to the role using nt security.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
create users dynamically