← Azure Data FactoryInformatica →

Privileges Required to use Sharepoint

To use Sharepoint, you need one of the following:

  • scheduler-administrator or redwood-administrator role.
  • scheduler-user or redwood-login role in combination with the following system-wide, partition-wide or object-level privileges.

Built-in Roles

  • The scheduler-administrator or redwood-administrator built-in role provides full control over Sharepoint.
  • The scheduler-viewer built-in role provides read-only access to Sharepoint.

Creating, Modifying, and Deleting Sharepoint Connections

You need all of the following privilege ranks to be able to create, modify, and delete Sharepoint:

  • View or any other rank - on the Redwood_Sharepoint extension point.
  • View or any other rank - on the Redwood_Connections extension point.
  • View or any other rank - on the existing process server and queue for the connection, if applicable.
  • Create - on process server and queue, if these need to be created.
  • Edit - on AZUConnection.
  • Edit - on SPTConnection.

Using Sharepoint

  • View or any other rank - on the Redwood_Sharepoint extension point.
  • View - on AZUConnection.
  • View - on AZUResGroup.
  • View - on the component's process server.
  • JobAdministrator - on the component's queue.
  • View - on the REDWOOD.Redwood_SharePointConnectionConstraint and REDWOOD.Redwood_SharePointDriveConstraint constraint definition.
  • View - on REDWOOD.Redwood_SharePoint library.
  • Submit - on process definitions REDWOOD.Redwood_Sharepoint_Delete_Item, REDWOOD.Redwood_Sharepoint_Download_File, REDWOOD.Redwood_Sharepoint_Move_Item, and REDWOOD.Redwood_Sharepoint_Upload_File.
  • View - on the REDWOOD.DataFactory library.

See Also

To use SharePoint, you need one of the following:

  • scheduler-administrator or redwood-administrator role.
  • scheduler-user or redwood-login role in combination with the following system-wide, partition-wide or object-level privileges.

Built-in Roles

  • The scheduler-administrator or redwood-administrator built-in role provides full control over all SharePoint connections.

Creating, Modifying SharePoint Connections

You need all of the following privilege ranks to be able to create and modify SharePoint connections:

  • View - on partitions GLOBAL and REDWOOD.
  • View - on application REDWOOD.Redwood_Sharepoint.
  • View - on the existing SharePoint process server and queue, if applicable.
  • Create - on process server and queue if a new process server and queue are required.
  • Submit - on process definition Sharepoint_Configure.
  • Either:
    • Create - on credential in the REDWOOD partition if a credential needs to be created.
    • Edit - on credential in the REDWOOD partition if a credential needs to be modified.

Using the SharePoint Component

You need all of the following privilege ranks to be able to use an SharePoint connection:

  • View - on partitions GLOBAL and REDWOOD.
  • View - on application REDWOOD.Redwood_Sharepoint.
  • View - on Redwood_SharePoint library.
  • Submit - on process definitions REDWOOD.Sharepoint_Upload_File, REDWOOD.Sharepoint_Download_File, REDWOOD.Sharepoint_Delete_File, and/or REDWOOD.Sharepoint_Move_File (depending on the functionality you want).
  • View - on the process server of the SharePoint connection.
  • JobAdministrator - on the queue of the SharePoint component.
  • View - on credential in the REDWOOD partition or on the credential to use.

Deleting SharePoint

  • View - on partition REDWOOD.
  • Delete - on credential in REDWOOD partition.

See Also

← Azure Data FactoryInformatica →