Documentation Center

Audience Manager and Outbound E-mail database security settings

This topic explains which database permissions are required for the Content Manager database.

Audience Manager database oedbuser
UserPermissionsReason
CONTACTSSELECT

INSERT

UPDATE

SELECT:
  • Getting a list of Contacts
  • Test/Send Mailing

INSERT, UPDATE:

  • Import Contacts
  • Processing bounce results (for statistics)
CONTACTS_EXTENDED_DETAILSSELECT

INSERT

UPDATE

SELECT:
  • Getting a list of Contacts
  • Test/Send Mailing

INSERT, UPDATE:

  • Import Contacts
  • Save Contacts
CONTACTS_KEYWORDSSELECT

INSERT

DELETE

SELECT:
  • Getting a list of Contacts
  • Test/Send Mailing

INSERT:

  • Import Keywords
  • Export Keywords

DELETE:

  • Import Keywords
DISTRIBUTIONLISTSSELECT

UPDATE

Refresh statistics
DISTRIBUTIONLISTS_CONTACTSSELECT

INSERT

SELECT:
  • Test/Send Mailing
  • Add to Static Distribution List

INSERT:

  • Add to Static Distribution List
GROUPSSELECT

UPDATE

SELECT:
  • Import Contacts

UPDATE:

  • Refresh statistics
KEYWORDSSELECT

INSERT

SELECT:
  • Getting a list of Contacts

INSERT:

  • Import Keywords
QUEUED_EMAILS_MESSAGESSELECT

INSERT

Send Mailing
QUEUED_EMAILSSELECT

INSERT

Send Mailing
EMAILSSELECTSend Mailing
EMAILSSTATUSESSELECT

INSERT

SELECT:
  • Getting a list of Contacts (for statistics)

INSERT:

  • Processing bounce results (for statistics)
EMAIL_STATUS_TYPESSELECTGetting a list of Contacts (for statistics)
IMPORT_CONTACTSSELECT

INSERT

ALTER

Import Contacts
IMPORT_KEYWORDSSELECT

INSERT

ALTER

Import Keywords
IMPORT_KEYWORDS_MAPPINGSSELECT

DELETE

Import Keywords
CONTACT_SYNCHRONIZATIONSELECT

INSERT

UPDATE

  • Import Contacts
  • Import Keywords
Subscription database oesmdbuser
UserPermissionsReason
CONTACTSSELECTReading a Contact.

Synchronization.

CONTACTS_EXTENDED_DETAILSSELECTReading a Contact.

Synchronization.

KEYWORDSSELECTSynchronization.
CONTACTS_KEYWORDSSELECTSynchronization.
Tracking database oepsduser
No specific permissions are required for the Tracking database as all access is handled through stored procedures.