.show policy managed_identity command
This command returns the ManagedIdentity policy of the cluster or the specified database.
Permissions
To see the managed identity policy on the cluster, you must have AllDatabasesMonitor permissions.
To see the managed identity policy on a database, you must have Database User, Database Viewer, or Database Monitor permissions.
For more information, see role-based access control.
Syntax
.show
cluster
policy
managed_identity
.show
database
DatabaseName policy
managed_identity
Learn more about syntax conventions.
Parameters
Name | Type | Required | Description |
---|---|---|---|
DatabaseName | string |
✔️ | The name of the database. |
Returns
This command returns a table that has a single record.
Column | Type | Description |
---|---|---|
EntityName | string |
The name of the entity the ManagedIdentity policy is defined on (or empty, if showing the cluster level policy) |
Policies | string |
A JSON array indicating all ManagedIdentity policies defined for the entity, formatted as ManagedIdentity policy objects |
Example
.show database MyDatabase policy managed_identity
EntityName | Policies |
---|---|
[MyDatabase] | [{"ObjectId": "f687680c-5ba0-4025-ab04-0433fdbd0086", "ClientId": "7c8fee41-97d1-4ebd-9140-32a3b8316820", "TenantId": "4549d41b-a99d-4367-a887-7dd2c00e542c", "DisplayName": "myManagedIdentity", "IsSystem": false, "AllowedUsages": "NativeIngestion, ExternalTable"}] |
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for