Category Archives: Security

  1. Why are my permissions missing?

    Leave a comment

    June 22, 2021 by Kenneth Fisher

    You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz …
    Continue reading

  2. #PowershellBasics: Finding a common AD group for a set of users.

    3

    June 17, 2021 by Kenneth Fisher

    A while back (almost 7 years 😲) I wrote a post on finding the common AD groups of a set …
    Continue reading

  3. What account is xp_cmdshell using?

    2

    May 25, 2021 by Kenneth Fisher

    It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. …
    Continue reading

  4. What is the CONTROL permission?

    1

    January 19, 2021 by Kenneth Fisher

    One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: …
    Continue reading

  5. Adding a user to an Azure SQL DB

    1

    November 5, 2020 by Kenneth Fisher

    Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t …
    Continue reading

  6. Permissions script for Azure Synapse

    3

    October 15, 2020 by Kenneth Fisher

    I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for …
    Continue reading

  7. As a DBA, am I a gatekeeper?

    6

    August 27, 2020 by Kenneth Fisher

    TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and …
    Continue reading

  8. HAL0004 – I don’t feel well Dave

    Leave a comment

    June 29, 2020 by Kenneth Fisher

    It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for …
    Continue reading

  9. I created a table and SQL created a schema and a user.

    Leave a comment

    June 22, 2020 by Kenneth Fisher

    Demo first and then I’ll explain what happened. First thing I did was run this script: CreateUsers.bat It’s a quick …
    Continue reading

  10. Could not obtain information about Windows NT group/user

    Leave a comment

    May 6, 2020 by Kenneth Fisher

    This is an interesting error that you’ll occasionally get when accessing an AD/Windows ID. Msg 15404, Level 16, State 11, …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,537 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013