2024-02-05
375 reads
2024-02-05
375 reads
2022-08-15
351 reads
2021-11-08
438 reads
2021-05-26 (first published: 2021-04-30)
7,908 reads
2018-02-01
863 reads
Learn how to find who has changed permissions from the default trace
2015-10-13
9,744 reads
This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.
2015-01-14 (first published: 2014-12-17)
5,880 reads
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
2014-03-20
22,772 reads
Someone, while locking down the SQL Server, removed the permissions by which the DBAs came in and administered the server. As a result, we cannot get back into SQL Server. How can we restore our access to SQL Server? Check out this tip to find out.
2012-03-29
4,423 reads
This script reverse engineers SQL statements to recreate database permissions.
2011-10-24 (first published: 2011-10-07)
14,590 reads
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers