Add an Oracle Database User that Connects to BI Publisher for Backup and Restore Functions

Add an Oracle database user called nncentral to connect BI Publisher database for backup and restore functions work properly. This task needs to be done for local installations only.

1. Log into the Oracle database.

   [oracle@vm ~]$ echo $ORACLE_SID
   AcmeBIPublis
   [oracle@vm ~]$ cd $ORACLE_HOME/bin/
   [oracle@vm bin]$ ./sqlplus '/as sysdba'

2. Create a user called nncentral and the user password.

   Note:

   The password that you configure expires after 180 days. Seven days before the password expires, a password expiry trap warns you through SDM that your password needs to be reset. If you need to reset this user password later, see the Reset the Password for the Oracle Database User section in the Oracle Communications Report Manager User Guide for more information.

   SQL> CREATE USER nncentral IDENTIFIED BY <password>;

3. Grant the appropriate privileges.

   SQL> GRANT CONNECT, DBA, SYSDBA, CREATE SESSION TO nncentral;

4. Exit the Oracle database prompt.

   SQL> exit