1 - Levels of security
PowerCenter provides the following levels of repository security:
2 - Tasks
A PowerCenter administrator can complete the following tasks:
- Create groups.
- Assign privileges to groups.
- Create users and assign them to groups.
3 - Privileges
You can create a repository user profile for each person working in the PowerCenter - Repository.
Each profile has a separate user name and password. You can also create user groups and assign each user to one or more groups. Then, grant repository privileges to each group so users in the group can perform repository tasks, such as using the Designer or creating workflows.
The repository user profile is different from the database user profile. Although a particular user might not have access to a database as a database user, that same person can have privileges to a repository in the database as a repository user.
From the PowerCenter - Repository Manager > connected to a repository > Security > Manage Users and Profiles
4 - Permissions
Permissions allow repository users to perform tasks within a folder. With folder permissions, you can control user access to the folder and the tasks you permit them to perform.
Folder permissions work closely with repository privileges. Privileges grant access to specific tasks, while permissions grant access to specific folders with read, write, and execute access. However, any user with the Super User privilege can perform all tasks across all folders in the repository.
Folders have the following types of permissions:
- Read permission. You can view the folder and objects in the folder.
- Write permission. You can create or edit objects in the folder.
- Execute permission. You can run or schedule workflows in the folder.
From the PowerCenter - Repository Manager > connected to a repository > Folder > Create