2012年2月11日星期六

Basic Windows Authentication Question

Hi there,
I want to give access to a database to all users in a domain
using Windows Authentication. I thought that this would be as simple as
adding a login which specifies the domain only, but this does not seem to be
possible. I can't believe that you have to enter every single domain user
as a login in SQL Server. Someone please tell me this is not the case!Hi,
Not required, Create OS Group and all the domain users to that group. After
that give the previlages to
that domain group to SQL Server.
Thanks
Hari
MCDBA
"Gorge Bush" <bill.gates@.microcock.cum> wrote in message
news:#FwxRFFVEHA.2320@.TK2MSFTNGP10.phx.gbl...
> Hi there,
> I want to give access to a database to all users in a
domain
> using Windows Authentication. I thought that this would be as simple as
> adding a login which specifies the domain only, but this does not seem to
be
> possible. I can't believe that you have to enter every single domain user
> as a login in SQL Server. Someone please tell me this is not the case!
>|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:e0rMaRFVEHA.2484@.TK2MSFTNGP11.phx.gbl...

> Not required, Create OS Group and all the domain users to that group.
After
> that give the previlages to
> that domain group to SQL Server.
O.K. Thanks, but the whole point of this exercise is to be able to identify
the user at the database level. Will the system_user or current_user
variables be set to the individual or the group?|||> O.K. Thanks, but the whole point of this exercise is to be able to
identify
> the user at the database level. Will the system_user or current_user
> variables be set to the individual or the group?
I answered that myself. It works!|||Hi,
Yes, you are correct.
Thanks
Hari
MCDBA
"Gorge Bush" <bill.gates@.microcock.cum> wrote in message
news:OpwBIeFVEHA.3788@.TK2MSFTNGP12.phx.gbl...
> identify
> I answered that myself. It works!
>|||Refer to information about the predefined Domain Users group at
http://www.microsoft.com/windows200...sp?url=/windows
2000/en/server/help/sag_SEconceptsImpGroups.htm
Then, just grant access to this group.
-Mark Shlimovich

没有评论:

发表评论