Stairway to SQL Server Security Level 4: Permissions

  • Don Kiely

    SSC Eights!

    Points: 849

    Comments posted to this topic are about the item Stairway to SQL Server Security Level 4: Permissions

  • andre.quitta

    SSCommitted

    Points: 1866

    We've had good success lumping similarly used tables and procedures into schemas and then creating a role for the schema and assigning "User" permissions to the role, specifically SELECT, INSERT, UPDATE, DELETE, EXECUTE. For more limited use, we'd also create the schema read only role, which only had access to SELECT.

    Your definitions were spot-on for assignment but it may be more difficult to maintain with multiple roles.

  • Don Kiely

    SSC Eights!

    Points: 849

    Thanks! Yes, and I talk about schemas and security in Level 5. And yes about multiple roles.

    Keeping it simple goes a long way in keeping things secure.

    Don

  • alicesql

    SSCrazy

    Points: 2471

    Very helpful to me today as I had a user who couldn't refresh a SharePoint SS due to a lack of access to the new view I had created. Thanks.

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

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