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

Remove-DbaDbRoleMember

Ben Miller (@DBAduck)

Remove-DbaDbRoleMember View Source Ben Miller (@DBAduck) Windows, Linux, macOS 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. Handles user removal from multiple roles simultaneously and works across multiple databases and instances.

Remove-DbaDbUser

Doug Meyers (@dgmyrs)

Remove-DbaDbUser View Source Doug Meyers (@dgmyrs) Windows, Linux, macOS 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. When a user owns schemas, the function intelligently manages the cleanup: schemas with the same name as the user are dropped (if empty), while other owned schemas have their ownership transferred to ‘dbo’.