Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2022-01-12 (first published: 2021-06-11)
9,064 reads
login
2019-04-22
994 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)
10,001 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)
720 reads
Blogs
Is Cataloging Your Data Important?
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
Daily Coping 20 Mar 2023
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Forums
airstream food trailer for sale uk
airstream food trailer for sale uk airstream food truck for sale uk american food...
Azure SQL - Restore to lower enviornment
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Bcp queryout issue
Hi all, I am running the following query in SQL, trying to export some...
Ask SSC