interMedia Text Users and Roles

With interMedia Text you can use CTXSYS user to administer users and CTXAPP role to create and delete interMedia Text preferences and use interMedia Text PL/SQL packages:

CTXSYS User

This user is created at install time. Administer interMedia Text users as this user. It has the following privileges:

• 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

Any user can create an interMedia Text index and issue a Text query. For additional tasks, use the CTXAPP role. This is a system-defined role that allows users to perform the following tasks:

• Create and delete interMedia Text preferences

• Use interMedia Text PL/SQL packages, such as the CTX_DDL package