Re: NT Active Directory Groups and SQL DB Roles
From: Steve Thompson (stevethompson_at_nomail.please)
Date: 02/23/05
- Next message: Steve Thompson: "Re: Public permissions"
- Previous message: Mike: "Public permissions"
- In reply to: GingerDeafMan: "NT Active Directory Groups and SQL DB Roles"
- Next in thread: Kevin McDonnell [MSFT]: "Re: NT Active Directory Groups and SQL DB Roles"
- Reply: Kevin McDonnell [MSFT]: "Re: NT Active Directory Groups and SQL DB Roles"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 23 Feb 2005 11:06:46 -0500
"GingerDeafMan" <gingerdeafmanNOSPAM@yahoo.co.uk> wrote in message
news:MPG.1c86922ff93c6b9c9896b4@news.individual.net...
> Is it possible to match SQL DB roles with Active Directory/NT groups?
>
> i.e. A user could be in 2 AD/NT groups (e.g. gAdmin and gUser). I then
> want this user to be member of rAdmin and rUser in my database.
>
> I am trying to allow the administration of users in AD/NT, rather than
> SQL Server.
I'm not entirely clear on your group analogy, to answer your last question.
You could restrict the ability of administrators in AD to have SQL Server
administrative rights by removing the BUILTIN\Administrators group from SQL
Server. Before removing the group, make sure you've added a custom nt group,
and granted sysadmin permissions to this group.
Steve
- Next message: Steve Thompson: "Re: Public permissions"
- Previous message: Mike: "Public permissions"
- In reply to: GingerDeafMan: "NT Active Directory Groups and SQL DB Roles"
- Next in thread: Kevin McDonnell [MSFT]: "Re: NT Active Directory Groups and SQL DB Roles"
- Reply: Kevin McDonnell [MSFT]: "Re: NT Active Directory Groups and SQL DB Roles"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
