Skip to main content

scope_access_review_history_definition

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

Overview

Namescope_access_review_history_definition
TypeResource
Idazure.authorization.scope_access_review_history_definition

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
createinsertscope, history_definition_idCreate a scheduled or one-time Access Review History Definition.
delete_by_iddeletescope, history_definition_idDelete an access review history definition.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
history_definition_idstringThe id of the access review history definition. Required.
scopestringThe scope of the resource. Required.

INSERT examples

Create a scheduled or one-time Access Review History Definition.

INSERT INTO azure.authorization.scope_access_review_history_definition (
displayName,
decisions,
scopes,
settings,
instances,
scope,
history_definition_id
)
SELECT
'{{ displayName }}',
'{{ decisions }}',
'{{ scopes }}',
'{{ settings }}',
'{{ instances }}',
'{{ scope }}',
'{{ history_definition_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Delete an access review history definition.

DELETE FROM azure.authorization.scope_access_review_history_definition
WHERE scope = '{{ scope }}' --required
AND history_definition_id = '{{ history_definition_id }}' --required
;