scope_access_review_schedule_definitions

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

Overview

Name	scope_access_review_schedule_definitions
Type	Resource
Id	azure.authorization.scope_access_review_schedule_definitions

Fields

vw_scope_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
type	text	The resource type.

scope_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, scope	Get single access review definition
list	SELECT	scope	Get access review schedule definitions
delete_by_id	DELETE	scheduleDefinitionId, scope	Delete access review schedule definition
stop	EXEC	scheduleDefinitionId, scope	Stop access review definition

SELECT examples

Get access review schedule definitions

vw_scope_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,
type
FROM azure.authorization.vw_scope_access_review_schedule_definitions
WHERE scope = '{{ scope }}';

scope_access_review_schedule_definitions

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

DELETE example

Deletes the specified scope_access_review_schedule_definitions resource.

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