Table of Contents

Search

  1. About the Security Guide
  2. Introduction to Informatica Security
  3. User Authentication
  4. LDAP Authentication
  5. Kerberos Authentication
  6. SAML Authentication for Informatica Web Applications
  7. Domain Security
  8. Security Management in Informatica Administrator
  9. Users and Groups
  10. Privileges and Roles
  11. Permissions
  12. Audit Reports
  13. Appendix A: Command Line Privileges and Permissions
  14. Appendix B: 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.
-

0 COMMENTS

We’d like to hear from you!