Creating Repository Users

Creating Repository Users and Groups

You can create a repository user profile for everyone working in the repository, each with 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 tasks within the repository (such as use the Designer or create workflows).

The repository user profile is not the same as the database user profile. While 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.

Informatica tools include two types of security:

Privileges. Repository-wide security that controls which task or set of tasks a single user or group of users can access.

Permissions. Security assigned to individual folders within the repository.

PowerCenter uses the following privileges:

Use Designer

Browse Repository

Use Repository Manager

Use Workflow Manager

Workflow Operator

Administer Repository

Administer Server

Super UserYou can perform various tasks for each privilege. Privileges depend on your group membership. Every repository user belongs to at least one group. For example, the user who administers the repository belongs to the Administrators group. By default, you receive the privileges assigned to your group. While it is most common to assign privileges by group, the repository administrator, who has either the Super User or Administer Repository privilege, can also grant privileges to individual users.

An administrator can perform the following tasks

Create groups.

Assign privileges to groups.

Create users and assign them to groups.

In the following steps, you will perform the following tasks:

1. Connect to the repository as an Administrator. If necessary, ask your administrator for the user name and password. Otherwise, ask your administrator to complete the lessons in this chapter for you.

2. Create a group called Group1. To do this, you need to log in to the repository as the


3. Assign privileges to the Group1 group.

4. Create a new user.

Connecting to the Repository

To perform the following tasks, you need to connect to the repository. If you are already

connected to the repository, disconnect and connect again to log in as the Administrator.

Otherwise, ask your administrator to perform the tasks in this chapter for you.

To connect to the Repository,

1. Launch the Repository Manager.

A list of all repositories appears in the Navigator.

2. Double-click on ur repository .

3. Enter the repository user name and password for the Administrator user. Click Connect.

The dialog box expands to enter additional information.

4. Enter the host name and port number needed to connect to the repository database.

5. Click Connect.

You are now connected to the repository as the Administrator user.


2 Responses

  1. Hi
    I am new to Informatica trying to learn now. Will you please explain me SCD type 2 mapping by taking EMP, DEPT as sources.
    Thanks in advance

  2. You can find some good interview Question Answers on Informatica in the below link


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: