Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
SQL database in Microsoft Fabric
Important
Microsoft Purview access policies for Azure SQL Database, Azure SQL Managed Instance, and Azure Arc-enabled SQL Server 2022 retire on October 30, 2027. Migrate the access these policies grant to SQL native roles and permissions. For more information, see Retirement of Microsoft Purview access policies for SQL. This retirement doesn't affect SQL database in Microsoft Fabric.
Lists all database and server principals created from Microsoft Entra ID (formerly Azure Active Directory) which are given connect permissions through external policies.
| Column name | Data type | Description |
|---|---|---|
| sid | varbinary(85) | SID (Security-IDentifier) of the principal. |
| aad_object_id | nvarchar(72) | Microsoft Entra Object ID of the principal. Is unique within an Azure tenant. |
| type | nvarchar(4) | Principal type: Z=External policy. |
| type_desc | nvarchar(60) | Description of the principal type: RBAC_ASSIGNED_USER. |
| authentication_type | int | Authentication type: 5. |
| authentication_type_desc | nvarchar(60) | Description of the authentication type: 5=AZURE_IAM_RBAC. |
Permissions
Principals must have the VIEW SERVER SECURITY STATE permission.