Permissions control the level of access that a user or group has on the connection.
You can configure permissions on a connection in the Analyst tool, Developer tool, or Administrator tool.
Any connection permission that is assigned to a user or group in one tool also applies in other tools. For example, you grant GroupA permission on ConnectionA in the Developer tool. GroupA has permission on ConnectionA in the Analyst tool and Administrator tool also.
Any connection permission that is assigned to a user or group in one tool also applies in other tools. For example, you grant GroupA permission on ConnectionA in the Developer tool. GroupA has permission on ConnectionA in the Administrator tool also.
The following Informatica components use the connection permissions:
Administrator tool. Enforces read, write, and execute permissions on connections.
Analyst tool. Enforces read, write, and execute permissions on connections.
Informatica command line interface. Enforces read, write, and grant permissions on connections.
Developer tool. Enforces read, write, and execute permissions on connections.
For SQL data services, the Developer tool does not enforce connection permissions. Instead, it enforces column-level and pass-through security to restrict access to data.
Data Integration Service. Enforces execute permissions when a user tries to preview data or run a mapping, scorecard, or profile.
You cannot assign permissions on the following connections: profiling warehouse, data object cache database, or Model repository.