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:

• CTXSYS User

• CTXAPP Role

• Granting Roles and Privileges to Users

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;

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

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.

See Also: “Creating an Oracle Text User”