SSIS Components for Microsoft SharePoint

Build 25.0.9434

BreakRoleInheritance

Removes inherited permissions from a SharePoint list or item, making it independent from its parent permissions. Useful for restricting or customizing access at a more granular level.

Input

Name Type Required Description
List String True The internal name of the SharePoint list where security inheritance will be broken. Helps apply unique permissions to the list or its items.
ItemId Int False The unique identifier of the list item for which security inheritance will be broken. Useful for setting item-level permissions.
CopyRoleAssignments Boolean False Indicates whether the existing role assignments should be copied from the parent object. If 'true', current permissions are retained; if 'false', all permissions are removed and must be reassigned.

The default value is true.

Result Set Columns

Name Type Description
Success Boolean Indicates whether the operation to break role inheritance was successful. Returns 'true' for success and 'false' for failure.
ErrorCode Integer If the procedure fails, this field displays the corresponding error code. Useful for debugging and troubleshooting.
ErrorMessage String If the procedure fails, this field provides a detailed error message explaining the failure. Helps diagnose security and permission issues.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434