Skip to main content

access_group_members

Creates, updates, deletes, gets or lists an access_group_members resource.

Overview​

Nameaccess_group_members
TypeResource
Idrailway.workspaces.access_group_members

Fields​

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
addinsertaccess_group_id, user_idAdd a workspace member to an access group. Backed by the Railway GraphQL mutation accessGroupMemberAdd.
removedeleteaccess_group_id, user_idRemove a member from an access group. Backed by the Railway GraphQL mutation accessGroupMemberRemove.

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
access_group_idstring
user_idstring

INSERT examples​

Add a workspace member to an access group. Backed by the Railway GraphQL mutation accessGroupMemberAdd.

INSERT INTO railway.workspaces.access_group_members (
access_group_id,
user_id
)
SELECT
'{{ access_group_id }}' /* required */,
'{{ user_id }}' /* required */
RETURNING
id,
access_group_id,
user_id,
access_group,
created_at,
updated_at,
user
;

DELETE examples​

Remove a member from an access group. Backed by the Railway GraphQL mutation accessGroupMemberRemove.

DELETE FROM railway.workspaces.access_group_members
WHERE
access_group_id = '{{ access_group_id }}' --required
AND user_id = '{{ user_id }}' --required
;