Skip to main content

team_member_roles

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

Overview​

Nameteam_member_roles
TypeResource
Idnvidia.orgs.team_member_roles

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
addinsertteam_name, user_email_or_id, rolesInvite if user does not exist, otherwise add role in team
removedeleteteam_name, user_email_or_idrolesRemove role in team if user exists, otherwise remove invitation

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
rolesarray
team_namestring
user_email_or_idstring
rolesarray

INSERT examples​

Invite if user does not exist, otherwise add role in team

INSERT INTO nvidia.orgs.team_member_roles (
team_name,
user_email_or_id,
roles
)
SELECT
'{{ team_name }}',
'{{ user_email_or_id }}',
'{{ roles }}'
RETURNING
activation_token,
nca_role,
request_status,
user,
user_roles
;

DELETE examples​

Remove role in team if user exists, otherwise remove invitation

DELETE FROM nvidia.orgs.team_member_roles
WHERE team_name = '{{ team_name }}' --required
AND user_email_or_id = '{{ user_email_or_id }}' --required
AND roles = '{{ roles }}'
;