Set-sqmBackupExcludePermission

Backup sqmSQLTool v1.8.2+

Grants SELECT, INSERT, and UPDATE permissions on master.dbo.sqm_BackupExclude to a login.

Examples

# Grant permissions to a Windows group on the local instance

# Grant permissions to a Windows group on the local instance
Set-sqmBackupExcludePermission -LoginName "CONTOSO\DBA-Team"

# Grant permissions to a SQL login on a remote instance

# Grant permissions to a SQL login on a remote instance
Set-sqmBackupExcludePermission -SqlInstance "SQL01" -LoginName "svc_backup"

# Preview what would happen without making any changes

# Preview what would happen without making any changes
Set-sqmBackupExcludePermission -SqlInstance "SQL01" -LoginName "CONTOSO\DBA-Team" -WhatIf