Security Guide

10.4.0
- 10.2 HotFix 2
- 10.2 HotFix 1
- 10.2
- 10.1.1 HotFix 1
- 10.1.1
- 10.0

Back Next

Create, Edit, and Delete Sources and Targets Privilege

Users assigned the Create, Edit, and Delete Sources and Targets privilege can create, edit, and delete cubes, dimensions, source definitions, and target definitions.

The following table lists the required permissions and the actions that users can perform with the Create, Edit, and Delete Sources and Targets privilege:

Permission	Description
Read on original folder Read and Write on destination folder	User is able to perform the following actions: Copy source and target objects to another folder. Copy source and target objects to another PowerCenter repository. Users must also have the Create, Edit, and Delete Sources and Targets privilege in the destination repository.
Read and Write on folder	User is able to perform the following actions: Change comments for a versioned source or target object. Check in and undo a checkout of source and target objects checked out by their own user account. Check out source and target objects. Copy and paste source and target objects in the same folder. Create, edit, and delete source and target objects. Import SAP functions. Import source and target objects using the Designer. Users must also have the Create, Edit, and Delete Design Objects privilege. Import source and target objects using the Repository Manager. Users must also have the Create, Edit, and Delete Design Objects and Create, Edit, and Delete Run-time Objects privileges. Generate and execute SQL to create targets in a relational database. Revert to a previous source or target object version.

Permission

Description

Read on original folder

Read and Write on destination folder

User is able to perform the following actions:

Copy source and target objects to another folder.

Copy source and target objects to another PowerCenter repository. Users must also have the Create, Edit, and Delete Sources and Targets privilege in the destination repository.

Read and Write on folder

User is able to perform the following actions:

Change comments for a versioned source or target object.

Check in and undo a checkout of source and target objects checked out by their own user account.

Check out source and target objects.

Copy and paste source and target objects in the same folder.

Create, edit, and delete source and target objects.

Import SAP functions.

Import source and target objects using the Designer. Users must also have the Create, Edit, and Delete Design Objects privilege.

Import source and target objects using the Repository Manager. Users must also have the Create, Edit, and Delete Design Objects and Create, Edit, and Delete Run-time Objects privileges.

Generate and execute SQL to create targets in a relational database.

Revert to a previous source or target object version.

Sources and Targets Privilege Group