Script DB Level Permissions v4.5
Script database and object level permissions for all database users
2019-07-03 (first published: 2019-06-10)
1,759 reads
Script database and object level permissions for all database users
2019-07-03 (first published: 2019-06-10)
1,759 reads
2019-04-22
944 reads
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
5,685 reads
The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.
2016-02-02 (first published: 2016-01-15)
592 reads
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
I have the following SQL Server 2005 tables: create table Cars ( CarID int,...
I have the following SQL Server 2005 tables: create table Cars ( CarID int,...
While trying, in SQL 2016 (13.0.5850.14), to see if CHOOSE allowed an inline query...