Skip to main content

users

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

Overview

Nameusers
TypeResource
Idaws.memorydb.users

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
acl_namesarrayThe names of the Access Control Lists to which the user belongs
arnstringThe Amazon Resource Name (ARN) of the user.
access_stringstringAccess permissions string used for this user.
authenticationobjectDenotes whether the user requires a password to authenticate.
minimum_engine_versionstringThe minimum engine version supported for the user
namestringThe name of the user
statusstringIndicates the user status. Can be "active", "modifying" or "deleting".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_usersselectregionReturns a list of users.
create_userinsertregion, UserName, AuthenticationMode, AccessStringCreates a MemoryDB user. For more information, see Authenticating users with Access Contol Lists (ACLs).
update_userupdateregion, UserNameChanges user password(s) and/or access string.
delete_userdeleteregionDeletes a user. The user will be removed from all ACLs and in turn removed from all clusters.

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
regionstringAWS region (default: us-east-1)

SELECT examples

Returns a list of users.

SELECT
acl_names,
arn,
access_string,
authentication,
minimum_engine_version,
name,
status
FROM aws.memorydb.users
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a MemoryDB user. For more information, see Authenticating users with Access Contol Lists (ACLs).

INSERT INTO aws.memorydb.users (
UserName,
AuthenticationMode,
AccessString,
Tags,
region
)
SELECT
'{{ UserName }}' /* required */,
'{{ AuthenticationMode }}' /* required */,
'{{ AccessString }}' /* required */,
'{{ Tags }}',
'{{ region }}'
RETURNING
user
;

UPDATE examples

Changes user password(s) and/or access string.

UPDATE aws.memorydb.users
SET
UserName = '{{ UserName }}',
AuthenticationMode = '{{ AuthenticationMode }}',
AccessString = '{{ AccessString }}'
WHERE
region = '{{ region }}' --required
AND UserName = '{{ UserName }}' --required
RETURNING
user;

DELETE examples

Deletes a user. The user will be removed from all ACLs and in turn removed from all clusters.

DELETE FROM aws.memorydb.users
WHERE region = '{{ region }}' --required
;