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,433 reads
login
2019-04-22
926 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)
4,503 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)
585 reads
Blogs
Publish ADF from code to further environments
By Kamil
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...
Getting the Proc Code–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Running SQL Server in Google Cloud Platform
By Daniel Janik
On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...
Forums
How to efficiently perform search on my DB and Word documents on my server?
So I'm building a system for a client and they want to have a...
Copy Azure SQL DB App data to Azure Synapse
Hello, I am looking for the best way to copy change data from my...
Enable normal user to execute a sys stored procedure
I tried GRANT EXECUTE ON OBJECT :: sys.sp.droprolemember TO John; GO Cannot find the...
Ask SSC