|Oracle8i interMedia Text Migration
Release 2 (8.1.6)
Part Number A77061-01
Administration, 3 of 7
In pre-8.1, a ConText user can be assigned one of three pre-defined ConText roles
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.
The CTXSYS user is created at install time. You administrate interMedia 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 a Text index and issue a Text query. The CTXAPP role allows users to create preferences and use the interMedia Text PL/SQL packages.
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.