Role
Defines user roles and permissions that are assigned within a Salesforce Marketing Cloud account. Each record specifies access levels, feature entitlements, and user group associations. This view supports auditing of security and access configurations.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM Account WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM Account WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')
SELECT * FROM Account WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | Specifies the system-controlled identifier (Id) that is used to uniquely identify the role object. This value is read-only. |
| CustomerKey | String | Specifies the user-supplied unique Id for the role object within the broader object type. This value is typically assigned through the user interface or an API workflow. |
| Name | String | Specifies the name of the role. This name is displayed in administrative tools and user-permissions settings. |
| Description | String | Provides descriptive information that is used to document the role's purpose, functional scope, or administrative use. |
| IsPrivate | Bool | Returns a value of 'true' when the role is a private role that is defined by a specific Salesforce Marketing Cloud account rather than by the platform. It returns a value of 'false' when the role is a standard role that is available across accounts. |
| IsSystemDefined | Bool | Returns a value of 'true' when the role is a system-defined role that is created and maintained by the Salesforce Marketing Cloud application. It returns a value of 'false' when the role is a custom role that is created and managed by an administrator. |
| Client_EnterpriseID | Long | Specifies the enterprise-level Id that is associated with the client in multi-business-unit environments. This value is reserved for future use. |
| Client_ID | Int | Specifies the Id of the client that owns or manages the role record. |
| Client_CreatedBy | Int | Specifies the Id of the user that is responsible for creating the role object. |
| CreatedDate | Datetime | Specifies the date and time when the role object was created. This value is read-only. |
| Client_ModifiedBy | Int | Specifies the Id of the user that is responsible for modifying the role object. |
| ModifiedDate | Datetime | Indicates the date and time when the role object was last modified. |
| PermissionSets | String | Specifies the permission sets that are applied to the role. Each permission set groups related capabilities that can be assigned collectively. |
| Permissions | String | Specifies the array of individual permissions that are associated with the role. Each permission defines a distinct operational capability within Salesforce Marketing Cloud. |