Category: Security

  • Broken ownership chain – Dynamic SQL

    Today I had a co-worker come to my desk wondering why his service was getting a permissions error when selecting from a table. His confusion was rooted in the fact that his service has been using this stored procedure for over a year. He is granting access to the underlying tables by granting execute rights […]

  • Creating Logins and Users – Why I can’t connect

    If you have ever used database projects with SSDT I’m sure you’ve experienced a situation where that user you just created yesterday is suddenly complaining to you that they can no longer access the database. Often this is because SSDT deployment can purge permissions if they aren’t in the project, either because the option is […]