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

infacmd sql Commands

infacmd sql Commands

To run infacmd sql commands, users must have one of the listed sets of domain privileges, Data Integration Service privileges, and domain object permissions.
The following table lists the required privileges and permissions for infacmd sql commands:
infacmd sql Command
Privilege Group
Privilege Name
Permission On...
ExecuteSQL
-
-
Based on objects that you want to access in your SQL statement
ListColumnPermissions
-
-
-
ListSQLDataServiceOptions
-
-
-
ListSQLDataServicePermissions
-
-
-
ListSQLDataServices
-
-
-
ListStoredProcedurePermissions
-
-
-
ListTableOptions
-
-
-
ListTablePermissions
-
-
-
PurgeTableCache
-
-
-
RefreshTableCache
-
-
-
RenameSQLDataService
Application Administration
Manage Applications
-
SetColumnPermissions
-
-
Grant on the object
SetSQLDataServicePermissions
-
-
Grant on the object
SetStoredProcedurePermissions
-
-
Grant on the object
SetTablePermissions
-
-
Grant on the object
StartSQLDataService
Application Administration
Manage Applications
-
StopSQLDataService
Application Administration
Manage Applications
-
UpdateColumnOptions
Application Administration
Manage Applications
-
UpdateSQLDataServiceOptions
Application Administration
Manage Applications
-
UpdateTableOptions
Application Administration
Manage Applications
-

Updated May 17, 2019


Explore Informatica Network