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 |
|
CoffeeAddict
Yak Posting Veteran
94 Posts |
 Posted - 2009-10-02 : 16:17:51
|
| I have a new db connection string and want to create a new user for our Database. Do I do this in Users under the Database or Security under sql server? I want it only for a specific database.Another issue I have is if I tried to add a new use under Users under the Database I'm trying to add to, it asks me for a login. When I look at any of our other user's properties they're sat to "Without Login". How can I create a user with a Without Login? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-10-02 : 16:21:11
|
| You need to first create the login under Security. While creating the login, you can also grant it access to the database and add it to a role if you'll be doing security via roles. Once the login has been created, you then can go to the Users section inside the database to give it more permissions.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
Creating a new User