access_review_instance_my_decisions

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

Overview

Name	access_review_instance_my_decisions
Type	Resource
Id	azure.authorization.access_review_instance_my_decisions

Fields

vw_access_review_instance_my_decisions

Name	Datatype	Description
id	text	The access review decision id.
name	text	The access review decision name.
applied_by	text	field from the properties object
applied_date_time	text	field from the properties object
apply_result	text	field from the properties object
decision	text	field from the properties object
decisionId	text	field from the properties object
insights	text	field from the properties object
justification	text	field from the properties object
principal	text	field from the properties object
principal_resource_membership	text	field from the properties object
recommendation	text	field from the properties object
resource	text	field from the properties object
reviewed_by	text	field from the properties object
reviewed_date_time	text	field from the properties object
scheduleDefinitionId	text	field from the properties object
type	text	The resource type.

access_review_instance_my_decisions

Name	Datatype	Description
id	string	The access review decision id.
name	string	The access review decision name.
properties	object	Approval Step.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get_by_id	SELECT	decisionId, id, scheduleDefinitionId	Get my single access review instance decision.
list	SELECT	id, scheduleDefinitionId	Get my access review instance decisions.
patch	UPDATE	decisionId, id, scheduleDefinitionId	Record a decision.

SELECT examples

Get my access review instance decisions.

vw_access_review_instance_my_decisions

SELECT
id,
name,
applied_by,
applied_date_time,
apply_result,
decision,
decisionId,
insights,
justification,
principal,
principal_resource_membership,
recommendation,
resource,
reviewed_by,
reviewed_date_time,
scheduleDefinitionId,
type
FROM azure.authorization.vw_access_review_instance_my_decisions
WHERE id = '{{ id }}'
AND scheduleDefinitionId = '{{ scheduleDefinitionId }}';

access_review_instance_my_decisions

SELECT
id,
name,
properties,
type
FROM azure.authorization.access_review_instance_my_decisions
WHERE id = '{{ id }}'
AND scheduleDefinitionId = '{{ scheduleDefinitionId }}';

UPDATE example

Updates a access_review_instance_my_decisions resource.

/*+ update */
UPDATE azure.authorization.access_review_instance_my_decisions
SET 
decision = '{{ decision }}',
justification = '{{ justification }}',
insights = '{{ insights }}'
WHERE 
decisionId = '{{ decisionId }}'
AND id = '{{ id }}'
AND scheduleDefinitionId = '{{ scheduleDefinitionId }}';