Required rights for database administrators

During the installation of the Central Designer application server, you are prompted to specify user names and passwords for:

Database Administrator
Database User

The installation uses the Database Administrator user name and password to create the Database User and grant that user rights to perform tasks for the Central Designer application. The default name for the Database Administrator is system, but it can be any user that you assign the rights to perform the following tasks.

Task	SQL	Automatically executed for
Create the Database User.	CREATE USER &1 IDENTIFIED BY &2 DEFAULT TABLESPACE &3; GRANT CONNECT TO &1; GRANT RESOURCE TO &1; GRANT CREATE VIEW TO &1;	All supported Oracle database software versions.
Allow the Database User to create function indexes.	GRANT QUERY REWRITE TO &1; GRANT CREATE SYNONYM TO &1; EXIT;	All supported Oracle database software versions.

Task

SQL

Automatically executed for

Create the Database User.

CREATE USER &1 IDENTIFIED BY &2

DEFAULT TABLESPACE &3;

GRANT CONNECT TO &1;

GRANT RESOURCE TO &1;

GRANT CREATE VIEW TO &1;

All supported Oracle database software versions.

Allow the Database User to create function indexes.

GRANT QUERY REWRITE TO &1;

GRANT CREATE SYNONYM TO &1;

EXIT;

All supported Oracle database software versions.

Note: In Oracle 11g and 12c, the Database Administrator user does not have the right to allow the Database User to execute jobs. For more information on how to assign the Database Administrator the necessary rights, see Granting the EXECUTE on SYS.DBMS_JOB right to the database administrator.