resource_permissions

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

Overview

Name	resource_permissions
Type	Resource
Id	aws.ssm_sap.resource_permissions

Fields

The following fields are returned by SELECT queries:

get_resource_permission

Name	Datatype	Description
policy	string

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_resource_permission	select	region		Gets permissions associated with the target database.
put_resource_permission	replace	region, ActionType, SourceResourceArn, ResourceArn		Adds permissions to the target database.
delete_resource_permission	delete	region		Removes permissions associated with the target database.

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.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

get_resource_permission

Gets permissions associated with the target database.

SELECT
policy
FROM aws.ssm_sap.resource_permissions
WHERE region = '{{ region }}' -- required
;

REPLACE examples

put_resource_permission

Adds permissions to the target database.

REPLACE aws.ssm_sap.resource_permissions
SET 
ActionType = '{{ ActionType }}',
SourceResourceArn = '{{ SourceResourceArn }}',
ResourceArn = '{{ ResourceArn }}'
WHERE 
region = '{{ region }}' --required
AND ActionType = '{{ ActionType }}' --required
AND SourceResourceArn = '{{ SourceResourceArn }}' --required
AND ResourceArn = '{{ ResourceArn }}' --required
RETURNING
policy;

DELETE examples

delete_resource_permission

Removes permissions associated with the target database.

DELETE FROM aws.ssm_sap.resource_permissions
WHERE region = '{{ region }}' --required
;