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 -
User Permissions Reason CONTACTSSELECTINSERTUPDATESELECT:- Getting a list of Contacts
- Test/Send Mailing
INSERT,UPDATE:- Import Contacts
- Processing bounce results (for statistics)
CONTACTS_EXTENDED_DETAILSSELECTINSERTUPDATESELECT:- Getting a list of Contacts
- Test/Send Mailing
INSERT,UPDATE:- Import Contacts
- Save Contacts
CONTACTS_KEYWORDSSELECTINSERTDELETESELECT:- Getting a list of Contacts
- Test/Send Mailing
INSERT:- Import Keywords
- Export Keywords
DELETE:- Import Keywords
DISTRIBUTIONLISTSSELECTUPDATERefresh statistics DISTRIBUTIONLISTS_CONTACTSSELECTINSERTSELECT:- Test/Send Mailing
- Add to Static Distribution List
INSERT:- Add to Static Distribution List
GROUPSSELECTUPDATESELECT:- Import Contacts
UPDATE:- Refresh statistics
KEYWORDSSELECTINSERTSELECT:- Getting a list of Contacts
INSERT:- Import Keywords
QUEUED_EMAILS_MESSAGESSELECTINSERTSend Mailing QUEUED_EMAILSSELECTINSERTSend Mailing EMAILSSELECTSend Mailing EMAILSSTATUSESSELECTINSERTSELECT:- Getting a list of Contacts (for statistics)
INSERT:- Processing bounce results (for statistics)
EMAIL_STATUS_TYPESSELECTGetting a list of Contacts (for statistics) IMPORT_CONTACTSSELECTINSERTALTERImport Contacts IMPORT_KEYWORDSSELECTINSERTALTERImport Keywords IMPORT_KEYWORDS_MAPPINGSSELECTDELETEImport Keywords CONTACT_SYNCHRONIZATIONSELECTINSERTUPDATE- Import Contacts
- Import Keywords
-
Subscription database
oesmdbuser -
User Permissions Reason 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.