interMedia Text Users and Roles

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

CTXSYS User

The CTXSYS user is created at install time. You administrate interMedia Text users as this user.

CTXSYS can do the following

• modify system-defined preferences

• drop and modify other user preferences

• call procedures in the CTX_ADM PL/SQL package to start servers and set system-parameters

• start a ctxsrv server

• query all system-defined views

• perform all the tasks of a user with the CTXAPP role

CTXAPP Role

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

• create and delete interMedia Text preferences

• use the interMedia Text PL/SQL packages

Any user can create an interMedia Text index and issue a Text query. The CTXAPP role allows users create preferences and use the PL/SQL packages.