Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2022-01-12 (first published: 2021-06-11)
13,305 reads
Script database and object level permissions for all database users
2022-01-12 (first published: 2021-06-11)
13,305 reads
2019-04-22
1,032 reads
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
12,280 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)
768 reads
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Please share a situation when enabling and taking further advantage of DBCC TRACEON -...
All, Need a linked server guru. Trying the following in a stored procedure: SET...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers