User performing search queries

The user who performs search queries uses the CONTAINS and SCORE functions in an SQL query against a Db2 column that has a text search index on it.

Depending on the access rights that users are granted on the table that the index is created on, the SQL query is permitted or rejected by Db2. Specific authorization for the text search feature is not required.

The user who performs search queries can include the following functionality in SQL queries:
  • Limit the text search based on the criteria that is specified by the search argument
  • Return a score indicating how well a document ranks with respect to the search argument