Tag Archives: security
-
What is the CONTROL permission?
1January 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 -
Adding a user to an Azure SQL DB
1November 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 -
Permissions script for Azure Synapse
3October 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 -
As a DBA, am I a gatekeeper?
6August 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 -
HAL0004 – I don’t feel well Dave
Leave a commentJune 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 -
I created a table and SQL created a schema and a user.
Leave a commentJune 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 -
Could not obtain information about Windows NT group/user
Leave a commentMay 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 -
Call to action: What do you own?
2April 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 -
Be warned: The way I’m feeling right now I might actually give you sysadmin when you ask for it.
4April 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 -
Has this login been used recently?
3April 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