UserWorkspaceRoles
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
| Name | Type | ReadOnly | Operators | Description |
| UserId [KEY] | String | False | = |
The user id in the form of an email address. |
| AccessRoleId [KEY] | Integer | False |
The user role id. | |
| AccessRoleName | String | False |
The user role name. | |
| WorkspaceId [KEY] | Integer | False |
The workspace id. | |
| WorkspaceName | String | False |
The workspace name. |