Skip to main content

databases_principals

Creates, updates, deletes, gets or lists a databases_principals resource.

Overview

Namedatabases_principals
TypeResource
Idazure.data_explorer.databases_principals

Fields

NameDatatypeDescription
namestringDatabase principal name.
appIdstringApplication id - relevant only for application principal type.
emailstringDatabase principal email if exists.
fqnstringDatabase principal fully qualified name.
rolestringDatabase principal role.
tenantNamestringThe tenant name of the principal
typestringDatabase principal type.

Methods

NameAccessible byRequired ParamsDescription
listSELECTclusterName, databaseName, resourceGroupName, subscriptionIdReturns a list of database principals of the given Kusto cluster and database.

SELECT examples

Returns a list of database principals of the given Kusto cluster and database.

SELECT
name,
appId,
email,
fqn,
role,
tenantName,
type
FROM azure.data_explorer.databases_principals
WHERE clusterName = '{{ clusterName }}'
AND databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';