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 |
|
CanadaDBA
583 Posts |
 Posted - 2005-09-23 : 14:21:26
|
| Is it possible to have SQL Server Group ID like Windows Group Id?Canada DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-23 : 15:16:06
|
| Yes, they are called roles.Tara |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2005-09-26 : 08:16:10
|
Thanks Tara. Like always, short and complete answers. :)Is it true that the roles are in database level. How about if I want a role that has access to both AccDB and InvDB? Can I create a server role? quote:
Originally posted by tduggan
Yes, they are called roles.Tara
Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-26 : 11:27:48
|
| No. You would need two roles since roles are at the database level. Roles are meant to hold a collection of users that require the same permissions inside the database.Tara |
|
|
|
|
|
|
SQL Server Group ID