Oracle Text Users and Roles

19.1 Oracle Text Users and Roles

While any user can create an Oracle Text index and enter a CONTAINS query, Oracle Text provides the CTXSYS user for administration and the CTXAPP role for application developers.

This section contains the following sections:

19.1.1 CTXSYS User

The CTXSYS user is created during installation and can:

View all indexes
Sync all indexes
Run ctxkbtc, the knowledge base extension compiler
Query all system-defined views
Perform all tasks of a user with the CTXAPP role

Note:

In earlier releases of Oracle Text, CTXSYS had SYSDBA privileges, and only CTXSYS users could perform certain functions, such as modifying system-defined preferences or setting system parameters.

Starting with Oracle Database Release 19c, the CTXSYS user is a schema only user. To use the CTXSYS schema, run the following statements:

connect / as sysdba;

alter session set CURRENT_SCHEMA=CTXSYS;

19.1.2 CTXAPP Role

The CTXAPP role is a system-defined role that enables users to:

Create and delete Oracle Text preferences
Use the Oracle Text PL/SQL packages

19.1.3 Granting Roles and Privileges to Users

The system uses the standard SQL model for granting roles to users. To grant an Oracle Text role to a user, use the GRANT statement.

In addition, to allow application developers to call procedures in the Oracle Text PL/SQL packages, you must explicitly grant EXECUTE privileges for the Oracle Text package to each user.