Bat and SQL script to generate DB user permissions for all Databases in SQL server
Get a list of all user permissions in a database
2025-10-15 (first published: 2025-10-13)
2,092 reads
Permissions
2025-08-11
101 reads
Cloning Master Admin User Permissions in Amazon RDS for SQL Server with Fine-Grained Control
This article explores how to securely clone the master user permissions in Amazon RDS for SQL Server using a custom stored procedure, usp_rds_clone_login. It outlines a step-by-step process to generate, review, and apply a script that replicates server- and database-level access from the master user to a new login without directly exposing elevated credentials. The guide emphasizes the principle of least privilege, supports named account management, and enables transparent, auditable permission handling for DBAs and applications. Designed for secure and scalable environments, this solution enhances operational security while maintaining administrative flexibility in Amazon RDS.
2025-07-09
935 reads
2024-02-05
441 reads
2022-08-15
380 reads
2021-11-08
469 reads
2021-05-26 (first published: 2021-04-30)
8,898 reads
2018-02-01
889 reads
Find Permission Changes In The Default Trace
Learn how to find who has changed permissions from the default trace
2015-10-13
12,135 reads
Find Deny permissions on database objects
This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.
2015-01-14 (first published: 2014-12-17)
7,028 reads
Blogs
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Forums
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For
Comments posted to this topic are about the item Vector Search in SQL Server...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers