Modify Your CA Business Intelligence r3.2 Installation to CA Business Intelligence Release 03.3.00 › Migration from MySQL to SQL Anywhere Database › SQL Anywhere Database Preparation Using Manual Procedures › Create BusinessObjects Enterprise User Accounts and Set Database Options

Create BusinessObjects Enterprise User Accounts and Set Database Options

Use the commands that apply to your environment to create BusinessObjects Enterprise User Accounts, assign the proper privileges to the accounts, and set the database options.

Note: The command line syntax in this procedure contains the variables that are defined in Command Line Syntax Variables. Replace these variables (in italics) with the values that are appropriate for your environment.

Follow these steps:

1. Open a command prompt window.
2. (Windows) Execute the following command to create a BusinessObjects Enterprise User Account in the CMS Repository database.

   SQLANYWHERE_DIR\dbisqlc.exe -q -c "uid=ADMIN_UID;pwd=ADMIN_PWD;
   server=SQLANYWHERE_SERVER;host=SQLANYWHERE_HOST:SQLANYWHERE_PORT;
   dbn=DATABASE_NAME" CREATE USER BOE_UID IDENTIFIED BY BOE_PWD
   

3. (UNIX) Execute the following command to create a BusinessObjects Enterprise User Account in the CMS Repository database.

   $SQLANYWHERE_DIR/dbisqlc -q -c "uid=$ADMIN_UID;pwd=$ADMIN_PWD;
   server=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;
   dbn=$DATABASE_NAME" CREATE USER "$BOE_UID" IDENTIFIED BY "$BOE_PWD"
   

4. (Windows) Execute the following command to assign proper privileges for the BusinessObjects Enterprise User Account in the CMS Repository database.

   SQLANYWHERE_DIR\dbisqlc.exe -q -c "uid=ADMIN_UID;pwd=ADMIN_PWD;
   server=SQLANYWHERE_SERVER;host=SQLANYWHERE_HOST:SQLANYWHERE_PORT;
   dbn=DATABASE_NAME" GRANT RESOURCE, VALIDATE, PROFILE, READFILE TO BOE_UID
   

5. (UNIX) Execute the following command to assign proper privileges for the BusinessObjects Enterprise User Account in the CMS Repository database.

   $SQLANYWHERE_DIR/dbisqlc -q -c "uid=$ADMIN_UID;pwd=$ADMIN_PWD;
   server=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;
   dbn=$DATABASE_NAME" GRANT RESOURCE, VALIDATE, PROFILE, READFILE TO "$BOE_UID"
   

6. (Windows) Execute the following command to create the BusinessObjects Enterprise User Account in the Audit database.

   SQLANYWHERE_DIR\dbisqlc.exe -q -c "uid=ADMIN_UID;pwd=ADMIN_PWD;
   server=SQLANYWHERE_SERVER;host=SQLANYWHERE_HOST:SQLANYWHERE_PORT;
   dbn=AUDIT_DATABASE_NAME" CREATE USER BOE_UID IDENTIFIED BY BOE_PWD
   

7. (UNIX) Execute the following command to create the BusinessObjects Enterprise User Account in the Audit database.

   $SQLANYWHERE_DIR/dbisqlc -q -c "uid=$ADMIN_UID;pwd=$ADMIN_PWD;
   server=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;
   dbn=$AUDIT_DATABASE_NAME" CREATE USER "$BOE_UID" IDENTIFIED BY "$BOE_PWD"
   

8. (Windows) Execute the following command to assign the proper privileges for the BusinessObjects Enterprise User Account in the Audit database.

   SQLANYWHERE_DIR\dbisqlc.exe -q -c "uid=ADMIN_UID;pwd=ADMIN_PWD;
   server=SQLANYWHERE_SERVER;host=SQLANYWHERE_HOST:SQLANYWHERE_PORT;
   dbn=AUDIT_DATABASE_NAME" GRANT RESOURCE, VALIDATE, PROFILE, READFILE TO BOE_UID
   

9. (UNIX) Execute the following command to assign the proper privileges for the BusinessObjects Enterprise User Account in the Audit database.

   $SQLANYWHERE_DIR/dbisqlc -q -c "uid=$ADMIN_UID;pwd=$ADMIN_PWD;
   server=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;
   dbn=$AUDIT_DATABASE_NAME" GRANT RESOURCE, VALIDATE, PROFILE, READFILE TO "$BOE_UID"