PreviousNextJavaScript must be enabled to correctly display this content
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.
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>;
Grant the
appropriate privileges.
SQL> GRANT CONNECT, DBA, SYSDBA, CREATE SESSION TO nncentral;