User | dbatools | Command-line superpowers for SQL Server automation

Remove-DbaDbRoleMember

Ben Miller (@DBAduck)

Remove-DbaDbRoleMember View Source Ben Miller (@DBAduck) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes database users from database roles across SQL Server instances. Description Removes database users from specified database roles, supporting both built-in roles (like db_datareader, db_datawriter, db_owner) and custom database roles. This function streamlines user access management when you need to revoke permissions during employee transitions, security reviews, or role-based access cleanup.

Remove-DbaDbUser

Doug Meyers (@dgmyrs)

Remove-DbaDbUser View Source Doug Meyers (@dgmyrs) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes database users from SQL Server databases with intelligent schema ownership handling Description Safely removes database users from SQL Server databases while automatically handling schema ownership conflicts that would normally prevent user deletion. This eliminates the manual process of identifying and resolving schema ownership issues before removing users.