June 24, 2013 at 10:15 am
I need to create a Distribution Group in sql server 2008, i have 100 SQL Users who wants readonly Access on SOme Databases :w00t:, now i dont want to create individual logins for them.. so how to do this easily??
Please provide detailed information 😉
************************************
Every Dog has a Tail !!!!! :-D
June 24, 2013 at 10:19 am
You can create logins in SQL that target an Active Directory security group. Then you can create the database users as appropriate for that login.
If you don't have a suitable group already or need a specific one, then that will need to be created in AD; if like me you haven't got domain admin I guess you'd need to request a domain admin to do that part for you.
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
June 24, 2013 at 10:34 am
But i dont know how to create that, can you provide a step by step instructed manual or any link which will guide me step by step.....
************************************
Every Dog has a Tail !!!!! :-D
June 25, 2013 at 6:46 am
Actual requirement is stated below from Client..
=============================
Please create new group "RnDServices_BOT" and add below users:
abc.xyz
bhn.iun
jhy.pou
ahyt.kuu
Provide the db owner rights to this group on Below server
VATNEWTOS01
VATNEWTOS03
====================
Please help me doing it.. as me doing it for first time.. and i didnt receive anything yet from Internet to make the task done :w00t: :crying:
************************************
Every Dog has a Tail !!!!! :-D
June 25, 2013 at 7:26 am
:w00t::w00t::w00t::w00t::w00t:
************************************
Every Dog has a Tail !!!!! :-D
June 26, 2013 at 6:08 am
Do you manage both Windows and SQL Server, or is there somebody else who manages Windows at your organisation.
If someone else manages Windows, then ask them to set up the group and put the users into it. You should not be doing this task.
If you manage both Windows and SQL Server, then you have a lot to learn. Talk to your employer about getting proper training. If you do need to create the group yuorself, use the NET GROUP command. If you do not know how to use NET GROUP, as Google for examples.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply