Using the Visutl Utility to Determine Visibility for a User

You can use the Visutl utility to determine if a user is authorized to view a record, and to identify a visibility rule that denies such authorization. If you encounter a situation where a user does not receive some records, then you can determine whether the user is currently authorized to view those records. In a Siebel implementation, visibility rules determine whether Siebel Remote includes a Siebel record in the Siebel database extract for the user and if it routes the record to the user during synchronization.

It is not necessary to stop all transaction routers before you start the Visutl utility because it creates a visdatautil.dbf file instead of using the visdata.dbf file that the transaction routers use.

For more information about:

Dock objects, see Examining Visibility Rules of the Dock Object.
How to run the Visutl utility, see 475691.1 (Article ID) on My Oracle Support. This document was previously published as FAQ 1163.

To use the Visutl utility to determine visibility for a user

In the Siebel application, locate the record that you must examine.
For example, to locate an opportunity, navigate to the opportunity screen, and then query the Opportunity Name field for the record.
With the record you located in Step 1 still chosen, Click Menu, and then the About Record menu item.
Note the value in the Row # field.
Configure parameters for the session.
For more information, see Configuring Session Parameters for a Utility.

Enter the following command in a single line:

visutl /u user_name /p password /a application_server_name /c odbc_data_source /d siebel_table_owner /n node_name /l log_file_name /v n or l or m or h or r

Use parameters described in the following table.

Parameter	Required	Description
u user_name	Required	The login name for the administrator.
p password	Required	The password for the administrator.
a application_server_name	Required	The name of the Siebel Server where the user synchronizes.
n node_name	Required	The remote client where the Visutl utility examines visibility. You must use all upper case characters.
l log_file_name	Optional	The name of the log file where the Visutl utility logs results. The default value is visutl.log in the current folder. To save the log in another location, you can specify a full path and file name.
v n or l or m or h or r	Optional	The level of detail that the Visutl utility displays while it runs and saves to the log: n is None l is Low m is Medium h is High r is Recursive In most situations, it is recommended that you use the h level. The recursive level does an exhaustive examination of the visibility rules that apply to a record. This level can degrade performance.

You can include parameters in any order.

The following is an example of a typical command that runs the Visutl utility:

visutl /u sadmin /p sadmin /a APPSVR01 /n JSMITH /v H

where:

Visutl is the name of the utility.
sadmin is the user name.
sadmin is the password.
APPSVR01 is the name of the Siebel Server.
JSMITH is the name of the node.
H specifies the level of detail to display and save.

When the Visutl utility prompts you for a table name, you must enter the name of the Siebel database table that contains the record you must examine.
For example, you enter S_ORG_EXT for an account record, or S_CONTACT for a contact record.
When the Visutl utility prompts you for a where clause, you must enter a valid where clause.
For example, if the row_id you noted in Step 3 is 7-4HWXY, then you enter the following clause:
```
where ROW_ID = '7-4HWXY'
```
When the Visutl utility prompts you for another where clause, you press the Enter key.
The Visutl utility displays information about a rule that grants or denies visibility to a user. It displays this information according to the level of detail you specify.