|Oracle Text Application Developer's Guide
Part Number A90122-01
Administration, 2 of 6
While any user can create an Oracle Text index and issue a CONTAINS query, Oracle Text provides the CTXSYS user for administration and the CTXAPP role for application developers.
The CTXSYS user is created at install time. You administer Oracle Text users as this user.
CTXSYS can do the following:
The CTXAPP role is a system-defined role that enables users to do the following:
Any user can create an Oracle Text index and issue a Text query. The CTXAPP role allows users create preferences and use the PL/SQL packages.
The system uses the standard SQL model for granting roles to users. To grant a 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 to each user EXECUTE privileges for the Oracle Text package.