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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2008-05-07 : 07:22:08
|
| Hello All,What would be the best way to grant access to a group using SQL Server and Oracle databases into my database? I was thinking I needed to create a User group and create a password for it first, then I add user into that group via windows authentication. The problem is I never created a user profile like this before and I would appreciate if someone can explain the process to me. Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-07 : 13:03:35
|
| If the users will be using Windows authentication, then no passwords are needed. Passwords are for SQL authentication.Are your users already in a Windows group? If so, just add that group to the SQL Server and grant the permissions that they need.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
|
|
|
How to add a user to a group