August 28, 2008 at 12:28 am
Hi All,
I have a question about adding user into a domain group.
I have a domain group which i have given permission to the sql server 2005. Now i want to add user into that group, so do i just have to
add user in that group through the active directory. Will it automatically get the permisson to the database same as that group or
I have to give permission to individual user.
Can any one please explain about adding user into the group for sql server 2005 and sql server 2000.
Thank you very much in advance.
Zombi.
August 28, 2008 at 1:03 am
Create a Domain Group such a-group1 and if possible create a reference group and name it a-group1 reference. Add a-group1 to be a member of the a-group1 reference group. Add users to the a-group1.
In SQL Server 2005 create a login for the a-group1 reference.
This should allow AD credentials to be used by SQL Server 2005.
Cheers.
August 28, 2008 at 3:30 am
to clarify on Karl's point further
create a domain local security group in AD which is assigned to the resource (i.e. add to sql server security as a login).
Then create a domain global security group in AD which has any windows users added who need to use the resource (i.e. login to sql server)
Finally add the domain global security group as a member of the domain local security group and there you have group based sql authentication
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 5:03 pm
Hi,
I think i have to explain my question more clearly. Actually i am maintaining sql server. Active directory is managed by other department. Now sometimes they asked me to add a new user and give access to the database in sql server. Now if i will create a new user each time in sql server then i will end up with big number of users.
There is actually a group available in the user list in sql server. And i want to add user to that group and assign permission. So how can i add user into that group?
Thank you very much for your time. Waiting for your reply.
Cheers
Zombi.
August 29, 2008 at 2:36 am
zombi (8/28/2008)
So how can i add user into that group?Thank you very much for your time. Waiting for your reply.
Cheers
Zombi.
via active directory!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply