Role

Remove-DbaDbRole

Ben Miller (@DBAduck), the dbatools team + Claude

Remove-DbaDbRole View Source Ben Miller (@DBAduck), the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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 and intelligently handling schema ownership. 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.

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

Claudio Silva (@ClaudioESSilva), claudioessilva.com

Remove-DbaServerRole View Source Claudio Silva (@ClaudioESSilva), claudioessilva.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Remove-DbaServerRoleMember

Mikey Bronowski (@MikeyBronowski), bronowski.it

Remove-DbaServerRoleMember View Source Mikey Bronowski (@MikeyBronowski), bronowski.it Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

← Previous

1 2

Page 2 of 2