Content Platform Engine, Version 5.2.1   Database:  SQL        

Content Platform Engine SQL Server account

A database user account that Content Platform Engine uses to connect to SQL Server databases containing the GCD and object stores.

Content Platform Engine database user (SQL Server)
Unique identifier
cpe_db_user
Description
The database accounts that Content Platform Engine uses to access SQL Server. You can use the same account for the GCD and object store databases. Or you can use one (for example, cpe_db_user1 ) for the GCD database and one for the object stores (for example, cpe_db_user2 .
cpe_db_user must be a SQL Server account. It does not have to be an account in the configured directory service.
Minimum required permissions
Use your database tools to grant each cpe_db_user at least the following database access permissions:
  • db_datawriter
  • db_datareader
  • db_ddladmin
  • public
Add these accounts to SQL Server's master database and grant the public role to each. When you perform the procedure described in the section on Configuring the JDBC distributed transaction components, these accounts will also be granted the SqlJDBCXAUser role.


Last updated: March 2016
p8psu013.htm

© Copyright IBM Corporation 2016.