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
login
2019-04-22
991 reads
Script DB Level Permissions v4.3
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
8,538 reads
Instance wide script to add user (the 4th way)
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
Blogs
Techorama 2022 – Session Materials
You can find my slidedeck for the session “Introduction to Azure Data Factory” on...
Daily Coping 24 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Notes on SQLSaturday Jacksonville 2022
By Andy Warren
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...
Forums
Logging sql stms into a table when there is a High cpu alert
Hi, Whenever I get an high cpu alert , be it non-working hours or...
Transactions names meaning In Transaction Logs
I am using .LDF file to get the information about when was DB last...
Iterate and reorganize subset of database tables
Ahoi, we are using the ola hallengren scripts to run the weekly index optimizer....
Ask SSC