Permissions can be specified on a data source in either of the following ways.

  • When creating or updating a data source on behalf of a user, an administrator can set permissions on the data source.
  • When sharing a data source, the data source owner must set permissions on the data source.

Any valid permissions specified on the data source will override the permissions of users that use the data source. The exact set of permissions must be specified on the data source as no permissions are inherited from the user or user's role. Permissions set on a group data source override permissions set on any of its member data sources.

The following permissions can be set on a data source.

Note: The SQLEditor permission cannot be set on a shared data source. It can only be set on a data source by an administrator on behalf of a user.
Name ID Description
ViewDataSource 2 The details of the data source may be viewed.
ModifyDataSource 3 The data source may be modified.
DeleteDataSource 4 The data source may be deleted.
UseDataSourceWithJDBC 5 The data source may be queried with the JDBC driver.
UseDataSourceWithODBC 6 The data source may be queried with the ODBC driver.
UseDataSourceWithOData 7 The data source may be queried with an OData application.
SQLEditor 10 The data source may be queried with the SQL Editor in the Web UI.