AccountUser

Represents an individual user who belongs to a specific Salesforce Marketing Cloud account. Each user record includes details such as roles, permissions, and access settings. This table supports queries and updates but does not allow deletions to protect account integrity.

Table-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 AccountUser WHERE Id = 123

SELECT * FROM AccountUser WHERE Id IN (123, 456)

SELECT * FROM AccountUser WHERE CreatedDate > '2017/01/25'

Insert

You must specify the following fields when inserting to this table: Client_Id, Name, Email, UserID, and Password.

INSERT INTO AccountUser (Client_Id, UserId, Name, Email, Password) VALUES (123, 'bcabsbasbcasb', 'Test', '[email protected]', 'testpas@2sowrd')

Update

You must specify the Id and the Client_Id in the WHERE clause when executing an update against this table.

UPDATE AccountUser SET Name = 'changed' WHERE Id = 123 AND Client_Id = 456

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Int	False	Specifies the unique identifier (Id) that the system assigns to the account user record.
CreatedDate	Datetime	False	Indicates the date and time when the account user record was created. This timestamp is maintained by the system.
ModifiedDate	Datetime	False	Indicates the most recent date and time when the account user record was changed. This value helps track administrative updates and audit activity.
Client_ID [KEY]	Int	False	Specifies the Id of the client that is associated with the account user. This value links the user to the appropriate Marketing Cloud client context.
AccountUserID	Int	False	Specifies the Id that is assigned by Salesforce Marketing Cloud for the account user. This Id uniquely identifies the user within the account and is required for administrative and API-level operations.
UserID	String	False	Specifies the Id of the user within the authentication and login system. This value is used for credential management and user lookup.
Name	String	False	Specifies the display name that is associated with the user. This value appears in administrative interfaces and access-management tools.
Email	String	False	Specifies the primary email address that is associated with the user. This value is used for login, notifications, and administrative communication.
MustChangePassword	Bool	False	Returns a value of 'true' when the user must change their password at the next login. It returns a value of 'false' when no password change is required.
ActiveFlag	Bool	False	Returns a value of 'true' when the user account is active and permitted to access the system. It returns a value of 'false' when the account is inactive or disabled.
ChallengePhrase	String	False	Specifies the phrase that the user selects for login assistance workflows. This phrase helps verify the user's identity during account recovery.
ChallengeAnswer	String	False	Specifies the answer that corresponds to the challenge phrase for login assistance. This value is validated during account recovery and authentication checks.
IsAPIUser	Bool	False	Returns a value of 'true' when the user is authorized to authenticate through API methods. It returns a value of 'false' when the user can access the system only through the user interface. API-enabled users retain their passwords until those passwords are explicitly changed.
NotificationEmailAddress	String	False	Specifies the email address to which system notifications, password alerts, and administrative messages for the user are sent.
Client_PartnerClientKey	String	False	Specifies the partner client key that is associated with this user when the account is integrated with a partner system. This value is available through the API and supports partner-driven provisioning workflows.
Password	String	False	Specifies the password that is assigned to the account user. This value is stored and handled according to Marketing Cloud's security protocols.
Locale_LocaleCode	String	True	Specifies the locale code that defines the user's regional formatting for dates, numbers, and language preferences.
TimeZone_ID	Int	True	Specifies the Id of the time zone that is associated with the user. This value determines how the platform displays time-based information to the user.
TimeZone_Name	String	True	Specifies the name of the time zone that is associated with the user. This value provides a readable reference that aligns with the user's TimeZone_ID.
CustomerKey	String	False	Specifies the user-supplied unique Id for this object within its object type. This value enables custom integration, mapping, and synchronization scenarios.
DefaultBusinessUnit	Int	False	Specifies the business unit that the user accesses by default upon login. This value determines the user's initial workspace and content scope.
LanguageLocale_LocaleCode	String	True	Specifies the locale code that determines the user's language and translation preferences within the interface.
Client_ModifiedBy	Int	False	Specifies the Id of the user who most recently modified this account user record. This value supports auditing and administrative traceability.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.

Build 25.0.9454