A database user account that Content Platform Engine uses to connect to SQL Server
databases containing the GCD and object stores.
Procedure
- Create the following database account after the SQL Server instance is created:
- 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.
Record this value in your customized Installation and Upgrade Worksheet. To find this property,
search the worksheet for instances of cpe_db_user.