Project User Privileges

When creating a new project, a project user schema is created. This user schema hosts all the tables that are used by the project for storing and retrieving data. Following are the required privileges for a project user schema:

Project User Schema Privilege Description
QUOTA UNLIMITED ON <default tablespace> Required for creating database objects that are owned by the project user schema. This privilege allows users to create tables in the default tablespace. It replaces the UNLIMITED TABLESPACE system privilege that gave users system privileges to create tables in any tablespace, including the SYSTEM tablespace.
CREATE SESSION This privilege is used to connect to the database user schema to perform required operations. For example creating database objects such as tables, and using them to insert, retrieve, and delete data.
  • CREATE TABLE
  • CREATE VIEW
  • CREATE TRIGGER
  • CREATE SEQUENCE
  • CREATE PROCEDURE

  • CTXAPP Role

For a description of these privileges, see Database Administrative User Privileges.