Enabling Text Search on Database User Schemas

Before you enable text search in ALM, you must perform a set up step on each database user schema on which you want to enable text search.

To enable text search on an Oracle database user schema:

As Admin user, run the following command:

GRANT CTXAPP to <database user schema>

To enable text search on an SQL database user schema:

Enable full text indexing:

EXEC sp_fulltext_database 'enable'