Role

Remove-DbaDbRole

Ben Miller (@DBAduck)

Remove-DbaDbRole View Source Ben Miller (@DBAduck) Windows, Linux, macOS Synopsis Removes custom database roles from SQL Server databases Description Removes user-defined database roles from SQL Server databases while protecting against accidental deletion of system roles. This function automatically excludes fixed database roles (like db_owner, db_datareader) and the public role, ensuring only custom roles created for specific security requirements can be removed. The function performs safety checks before removal, preventing deletion of roles that own database schemas to avoid orphaning database objects.

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-DbaServerRole

Claudio Silva (@ClaudioESSilva), claudioessilva.com

Remove-DbaServerRole View Source Claudio Silva (@ClaudioESSilva), claudioessilva.com Windows, Linux, macOS Synopsis Removes custom server-level roles from SQL Server instances. Description Removes custom server-level roles that are no longer needed from SQL Server instances. This function helps clean up security configurations by permanently dropping user-defined server roles while preserving built-in system roles. Use this when decommissioning applications, consolidating permissions, or cleaning up after security audits. The operation requires confirmation due to its permanent nature and potential security impact.

Remove-DbaServerRoleMember

Mikey Bronowski (@MikeyBronowski), bronowski.it

Remove-DbaServerRoleMember View Source Mikey Bronowski (@MikeyBronowski), bronowski.it Windows, Linux, macOS Synopsis Revokes server-level role membership from SQL Server logins and roles. Description Revokes membership from server-level roles by removing logins or nested roles from target roles like sysadmin, dbcreator, or custom server roles. This is essential for security management when you need to reduce user privileges or clean up role assignments after organizational changes. The function works with both fixed server roles (sysadmin, securityadmin, etc.

← Previous

1 2

Page 2 of 2