1. Installation Guide
  2. Preparing the database server
  3. Required rights for database administrators

Required rights for database administrators

The database administrator must create the Oracle Central Designer database user before you install the Oracle Central Designer application. During the Oracle Central Designer installation, you are prompted to enter the user name and password for the Oracle Central Designer database user. For more information, see Creating the Central Designer database user.

The database administrator can be any user that has 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;

All supported Oracle database software versions.

Note:

The database administrator user does not have the rights to grant the database user execute privileges on required packages. For information on how to assign the database administrator the necessary rights, see Granting the database administrator the EXECUTE privilege on required packages.

For more information, see:

Parent topic: Preparing the database server