Thursday, March 8, 2012

Assign Windows Group Owner to SQL Server Group

A Windows Group has created (FDG\BGU-DATAREADER-HOU), I
used this Windows Group to add to SQL Server databases.
How do I add an owner to this Windows Groups?
Thank You,
DeanHi,
Did you mean a db_owner role in SQL server database. If yes then
Go to Security tab in SQL server and then select properties of that group.
After that select the database access and give db_owner on the selected
database.
Else you can use the below procedure to give db_owner role.
sp_addrolemember 'db_owner','user'
Thanks
Hari
MCDBA
"Dean" <anonymous@.discussions.microsoft.com> wrote in message
news:145301c3df76$1ddca400$a601280a@.phx.gbl...
> A Windows Group has created (FDG\BGU-DATAREADER-HOU), I
> used this Windows Group to add to SQL Server databases.
> How do I add an owner to this Windows Groups?
> Thank You,
> Dean
>
>
>

No comments:

Post a Comment