Query user roles for each workspace in Marketo.

Select

Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.

For example, the following query is processed server-side:

	SELECT * FROM UserWorkspaceRoles WHERE UserId='[email protected]'

Insert

	INSERT INTO UserWorkspaceRoles (UserId, WorkspaceId, AccessRoleId) VALUES ('[email protected]', 0, 1002)

Delete

	DELETE FROM UserWorkspaceRoles WHERE UserId='[email protected]' AND AccessRoleId=1002 AND WorkspaceId=0;

Columns