Table of Contents

Search

  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

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