Post reply

Grant everyone permission to a database

  • June 13, 2012 at 2:09 am

    #262846

    Hi,

    I need to grant everyone on the network read-only access to a specific database. What would be the best (and quickest!) way of doing this without having to add every single user to an AD group?

    Regards

    Andrew

  • June 13, 2012 at 2:22 am

    #1500198

    NT AUTHORITY\Authenticated Users

    That group contains anyone who has a AD account, so will fit your needs.

  • June 13, 2012 at 2:40 am

    #1500204

    Hi,

    Thanks for the reply.

    Would that though give anyone in the forest permission not just the local domain the SQL server sits on?

    Andrew

  • June 13, 2012 at 2:44 am

    #1500206

    Yes it is the whole forest as long as the nessesary trusts have been setup between the domains.

  • June 20, 2012 at 11:23 pm

    #1503762

    Just to make sure you are aware, it is recommended to never do this. You should take the extra step to ensure you are abl eto control who has access to your server.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply