Security Guide

10.5.2
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1

Back Next

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	-

Rename Saved Search

Table of Contents

Security Guide

Security Guide

infacmd sql Commands

infacmd sql Commands