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 > Controlling user access and security > User roles > Set database access for a user role

Set database access for a user role

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 a user role, follow these steps:

Click System Administration > Ongoing Maintenance > User Roles.
Type or select optional search criteria, and then click Search.
Select a user role from the record list.
Select the Data Access tab.
To add a new Data Access record, follow these steps:
1. Click Data Access Records.
  
  The Database Manager Data Access form opens.
2. Click Fill in the Database Table Name field to select a table.
3. The user role you initially selected is in the User Role field. If you want to add access to a different user role than the one you selected, clear the field and click Fill to select a different user role.
4. To set the database access, select one of the following:
  - Allow DB access: The user role specified is granted access to the table specified.
  - Prohibit DB access: The user role 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.
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