| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_server_external_policy_roles (Transact-SQL) |
Reference documentation to explain sys.dm_server_external_policy_roles (Transact-SQL) dynamic management view. |
srdan-bozovic-msft |
srbozovi |
11/07/2022 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE sqlserver2022]
List all available roles, independently of them being used or not. Not all roles listed may be applicable to SQL Server.
| Column name | Data type | Description |
|---|---|---|
| role_name | nvarchar(128) | ID for joining with other dynamic management views. |
| role_guid | nvarchar(128) | The role name as defined in external policy source. Has to be unique. |
| modify_date | datetime2 | Time when the role definition was changed. |
Principals must have the VIEW SERVER SECURITY STATE permission.
sys.dm_server_external_policy_principal_assigned_actions (Transact-SQL)