Tag Archives: security
-
Is it just me or does msdb feel a lot like a user database?
Leave a commentJuly 17, 2019 by Kenneth Fisher
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to …
Continue reading -
Introducing sp_AzSQLDBPermissions (Beta)
8June 27, 2019 by Kenneth Fisher
I’ve written a version of my permissions scripts for Azure SQL Database. It’s still in Beta but I’m confident enough …
Continue reading -
What does the User Mapping tab of Login Properties really tell us.
4June 24, 2019 by Kenneth Fisher
In case it’s not clear, we are talking about the Login Properties GUI in SQL Server Management Studio (SSMS). Now, …
Continue reading -
What permissions do temp stored procedures use?
4June 19, 2019 by Kenneth Fisher
In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting …
Continue reading -
How do I force a SQL Login to change it’s password on next login
2June 5, 2019 by Kenneth Fisher
Forcing someone to change their password on a periodic basis is a pretty common thing, and any time I’ve gotten …
Continue reading -
I’m moving my permissions scripts to GitHub
2May 30, 2019 by Kenneth Fisher
I’ve written very few things that I’m more proud of than my permissions scripts, sp_SrvPermissions and sp_DBPermissions. These scripts are …
Continue reading -
Security Learning Pathway at PASS Summit.
1May 17, 2019 by Kenneth Fisher
This year PASS is trying something new at PASS Summit. There are going to be Learning Pathways. A learning pathway …
Continue reading -
Why am I getting an NT AUTHORITY\ANONYMOUS error when creating or altering a stored procedure?
1May 8, 2019 by Kenneth Fisher
If you have to deal with linked servers then you probably have or will run into the following error: Login …
Continue reading -
db_owner in msdb == sysadmin
2May 6, 2019 by Kenneth Fisher
This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner …
Continue reading -
How do I let someone execute a SQL Agent job they don’t own?
2April 15, 2019 by Kenneth Fisher
In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
Continue reading
