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)
1,850 reads
Permissions
2025-08-11
90 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
632 reads
2024-02-05
412 reads
2022-08-15
365 reads
2021-11-08
459 reads
2021-05-26 (first published: 2021-04-30)
8,846 reads
2018-02-01
877 reads
Find Permission Changes In The Default Trace
Learn how to find who has changed permissions from the default trace
2015-10-13
11,893 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)
6,963 reads
Blogs
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Plan your 2026
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Forums
Fantasy Football 2026
The thread for the league in 2026. Players from last year have priority.
Certificates expired - Can't restore after creating new certificate
The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...
advice on diving into devops for managing BI projects
hi , i know this is a sql server forum but i think my...
Question of the Day
Which Table I
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers