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'