sys.dm_external_provider_certificate_info (Transact-SQL)
Applies to: SQL Server 2022 (16.x)
Note
This view is introduced in SQL Server 2022 CU1.
Returns information about the Azure cloud certificates used in SQL Server to set up and maintain a Microsoft Entra administrator required to support Microsoft Entra authentication. For more information, see Set up Microsoft Entra authentication for SQL Server.
Column name | Data type | Description |
---|---|---|
Subject | nvarchar(4000) | The subject name of the certificate. |
thumbprint | nvarchar(4000) | Certificate thumbprint. |
expire_date | datetime2 | Certificate expiration date and time. |
is_readable | bit | Indicates whether the certificate is readable for both public and private key. Values are: 1 - Yes 0 - No |
is_missing | bit | Indicates whether the certificate is present in the certificate store. Values are: 1 - Yes 0 - No |
Permissions
Principals must have the VIEW SERVER SECURITY STATE permission.
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
See also
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho