Table of Contents

  1. About the Security Guide
  2. Introduction to Informatica Security
  3. User Authentication
  4. LDAP Security Domains
  5. Kerberos Authentication
  6. Domain Security
  7. SAML Authentication for Informatica Web Applications
  8. Security Management in Informatica Administrator
  9. Users and Groups
  10. Privileges and Roles
  11. Permissions
  12. Audit Reports
  13. Command Line Privileges and Permissions
  14. Custom Roles
  15. Default List of Cipher Suites

Security Guide

Security Guide

Types of SQL Data Service Permissions

Types of SQL Data Service Permissions

You can assign the following permissions to users and groups:
  • Grant permission. Users can grant and revoke permissions on the SQL data service objects using the Administrator tool or using the infacmd command line program.
  • Execute permission. Users can run virtual stored procedures in the SQL data service using a JDBC or ODBC client tool.
  • Select permission. Users can run SQL SELECT statements on virtual tables in the SQL data service using a JDBC or ODBC client tool.
Some permissions are not applicable for all SQL data service objects.
The following table describes the permissions for each SQL data service object:
Object
Grant Permission
Execute Permission
Select Permission
SQL data service
Grant and revoke permission on the SQL data service and all objects within the SQL data service.
Run all virtual stored procedures in the SQL data service.
Run SQL SELECT statements on all virtual tables in the SQL data service.
Virtual table
Grant and revoke permission on the virtual table.
-
Run SQL SELECT statements on the virtual table.
Virtual stored procedure
Grant and revoke permission on the virtual stored procedure.
Run the virtual stored procedure.
-

Updated May 17, 2019


Explore Informatica Network