Siebel Remote and Replication Manager Administration Guide > Troubleshooting Siebel Remote > Using Troubleshooting Utilities >
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 if the user is currently authorized to view those records. In a Siebel implementation, visibility rules determine if 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:
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.
|
|
|
/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 pwd /a APPSVR01 /n JSMITH /v H
where:
- visutl is the name of the utility.
sadmin is the user name.
- pwd 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.
Running the Visutl Utility on a Cluster
To run the Visutl utility on a cluster, you specify the name of the cluster in the _CLUSTER_NETWORK_NAME_ environment variable. To run the Visutl utility on a cluster
- Add the following line to the siebenv.bat file:
set _CLUSTER_NETWORK_NAME_= cluster name
where:
- Run the siebenv.bat file.
- Run the Visutl utility.
|