Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.41

Administer > Application Setup > Adding users > Operator records > Set database access for an operator

Set database access for an operator

Applies to User Roles:

System Administrator

Database access is a feature that gives you the ability to limit or grant access to database records, such as contacts, company, and regions. You can add or modify the existing out-of-box database access settings per user role or operator.

To set database access for an operator, follow these steps:

Click System Administration > Ongoing Maintenance > Operators.
Type or select optional search criteria, and then click Search.
Select an operator record from the record list.
Select the Data Access tab in the General tab.
To add a new Data Access record, follow these steps:
1. Click Add new Data Access Record.
  
  The Database Manager Data Access form opens.
2. Click Fill in the Database Table Name field to select a table.
3. The operator name you initially selected is in the Operator Name field. If you want to add access to a different operator name than the one you selected, clear the field and click Fill to a select a different operator name.
4. To set the database access, select one of the following:
  - Allow DB access: The operator specified is granted access to the table specified.
  - Prohibit DB access: The operator specified is denied access to the table specified.
5. When access has been granted to a table, click Fill in the View Format field to select the table view.
6. Click Add.
  
  The new database access record is added.
To modify an existing database access record, follow these steps:
1. Select the Data Access tab in the General tab.
2. Double-click the Table Name of the existing database access record you want to modify.
  
  The Database Manager Data Access form opens.
3. Make the necessary edits.
4. Click Save.
  
  Your changes are saved.
Click OK.

Send Help Center feedback