Security Guide > Command Line Privileges and Permissions > 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
-