Security Guide

Back Next

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.	-

Rename Saved Search

Table of Contents

Security Guide

Security Guide

Types of SQL Data Service Permissions

Types of SQL Data Service Permissions