access_review_schedule_definitions

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

Overview

Name	access_review_schedule_definitions
Type	Resource
Id	azure.authorization.access_review_schedule_definitions

Fields

vw_access_review_schedule_definitions

Name	Datatype	Description
id	text	The access review schedule definition id.
name	text	The access review schedule definition unique id.
backup_reviewers	text	field from the properties object
created_by	text	field from the properties object
description_for_admins	text	field from the properties object
description_for_reviewers	text	field from the properties object
display_name	text	field from the properties object
instances	text	field from the properties object
reviewers	text	field from the properties object
reviewers_type	text	field from the properties object
scheduleDefinitionId	text	field from the properties object
scope	text	field from the properties object
settings	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The resource type.

access_review_schedule_definitions

Name	Datatype	Description
id	string	The access review schedule definition id.
name	string	The access review schedule definition unique id.
properties	object	Access Review.
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get_by_id	SELECT	scheduleDefinitionId, subscriptionId	Get single access review definition
list	SELECT	subscriptionId	Get access review schedule definitions
delete_by_id	DELETE	scheduleDefinitionId, subscriptionId	Delete access review schedule definition
stop	EXEC	scheduleDefinitionId, subscriptionId	Stop access review definition

SELECT examples

Get access review schedule definitions

vw_access_review_schedule_definitions

SELECT
id,
name,
backup_reviewers,
created_by,
description_for_admins,
description_for_reviewers,
display_name,
instances,
reviewers,
reviewers_type,
scheduleDefinitionId,
scope,
settings,
status,
subscriptionId,
type
FROM azure.authorization.vw_access_review_schedule_definitions
WHERE subscriptionId = '{{ subscriptionId }}';

access_review_schedule_definitions

SELECT
id,
name,
properties,
type
FROM azure.authorization.access_review_schedule_definitions
WHERE subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified access_review_schedule_definitions resource.

/*+ delete */
DELETE FROM azure.authorization.access_review_schedule_definitions
WHERE scheduleDefinitionId = '{{ scheduleDefinitionId }}'
AND subscriptionId = '{{ subscriptionId }}';