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
;