Results 1 to 3 of 3
Thread: new database user
Jun 22, 2003, 11:50 #1
new database user
i have an asp app runing with sql server 2000 and i have created a user in the database called ahmed with some good permissions
till now it's cool .....
now i need to create an ew user with another permissions so i found that i must specify another login name
the user name ahmed has the login name THINK-TANK\IUSR_THINK-TANK
(my computer name is think-tank)
so what is the right login name for the new user and what is the different between login names ?
and also how can i create a new password for the new user
Jun 23, 2003, 04:02 #2
any ideas ?
Jun 23, 2003, 07:13 #3
Well, you seem to be confusing things.
You have created a login for a windows user (THINK-TANK\IUSR_THINK-TANK). You can also create SQL Users for use only in the Database and not within Windows. When using SQL Enterp. manager, just type in a new Username instead of choosing one from the list. In the next stage you can assign a password to your (database) user.