Table of Contents

Search

  1. About the Security Guide
  2. Introduction to Informatica Security
  3. User Authentication
  4. LDAP Security Domains
  5. Kerberos Authentication Setup
  6. Domain Security
  7. Security Management in Informatica Administrator
  8. Users and Groups
  9. Privileges and Roles
  10. Permissions
  11. Audit Reports
  12. Command Line Privileges and Permissions
  13. Custom Roles

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 April 29, 2019