Roles and Users

pre-8.1

In pre-8.1, a ConText user can be assigned one of three pre-defined ConText roles

• CTXADMIN

• CTXAPP

• CTXUSER

8.1

In 8.1, the CTXADMIN and CTXUSER roles are obsolete.

In 8.1, CTXSYS is a user created at install time. The system also defines the CTXAPP role.

CTXSYS User

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

CTXSYS can do the following

• start a ctxsrv server

• 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

• 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 a Text index and issue a Text query. The CTXAPP role allows users to create preferences and use the interMedia Text PL/SQL packages.

Granting Roles and Privileges to Users

In pre-8.1, the system uses the standard SQL model for granting roles to users. This model has not changed for interMedia Text 8.1. To grant a Text role to a user, you use SQL GRANT command.

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