Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2022-01-12 (first published: 2021-06-11)
5,249 reads
Script database and object level permissions for all database users
2022-01-12 (first published: 2021-06-11)
5,249 reads
2019-04-22
991 reads
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
8,538 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)
665 reads
You can find my slidedeck for the session “Introduction to Azure Data Factory” on...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Andy Warren
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...
Hi, Whenever I get an high cpu alert , be it non-working hours or...
I am using .LDF file to get the information about when was DB last...
Ahoi, we are using the ola hallengren scripts to run the weekly index optimizer....