Tag Archives: security

  1. Adding a user to an Azure SQL DB


    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

  2. Permissions script for Azure Synapse


    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

  3. As a DBA, am I a gatekeeper?


    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

  4. 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

  5. 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

  6. 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

  7. Call to action: What do you own?


    April 29, 2020 by Kenneth Fisher

    You restored that database, did you remember to change the owner or is it still you? How about that job …
    Continue reading

  8. Be warned: The way I’m feeling right now I might actually give you sysadmin when you ask for it.


    April 20, 2020 by Kenneth Fisher

    You want sysadmin permissions in production? And your manager has approved it so I shouldn’t have any problems giving it …
    Continue reading

  9. Has this login been used recently?


    April 8, 2020 by Kenneth Fisher

    I get asked this every now and again, along with the companion When was the last time this login was …
    Continue reading

  10. Changing the owner of a schema removes all direct permissions of objects owned by the schema.

    Leave a comment

    January 22, 2020 by Kenneth Fisher

    This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow …
    Continue reading

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

Join 3,155 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013