How to: |
The SET PERMPASS=password command establishes a password that the user cannot change for access to data sources. You can control whether a PERMPASS is sent to the WebFOCUS Reporting Server with each request by choosing an option for the IBIF_dbapass_src variable.
The DBA password defines access to data sources on the WebFOCUS Reporting Server. Each data source description can specify which passwords are acceptable for accessing the data source. Each password may also be associated with specific access types, conditions and rules that limit access down to the row level if necessary.
Database security is described in the Describing Data With WebFOCUS Language manual.
By setting the DBA password for each request, you establish a single signon from Managed Reporting in the front end to the data source on the WebFOCUS Reporting Server.
ReportCaster also supports the DBA password, which is sent in encrypted form to ReportCaster. The DBA password cannot be assigned a group ID because a single password can be associated with multiple groups. It can be set to the domain ID, the user HREF, or to a user-specified variable.
- Click Configuration and then Client Settings.
-
Select
the Managed Reporting category and then the IBIF_dbapass_src variable.
-
Select
one of the following options:
- OFF. This option sets IBIF_dbapass_src to blank and does not pass a DBA password with each request.
-
MR Id. This
option sets IBIF_dbapass_src to the value of the CURRENT_USER_FILE
variable. CURRENT_USER_FILE is the WFS variable that holds the href
of the current user. The href is normally in the form filename.ext (for
example, sally02.htm), where the file name may be a maximum of eight
characters. The file name portion of the href without the extension
will be sent to the WebFOCUS Reporting Server as the DBA
password (SET PERMPASS=dbapass) prefixed to each request.
Note: If a Managed Reporting Repository Driver populates user hrefs from an outside source with file names greater than eight characters, the SET PERMASS=dbapass syntax fails, the server returns an error, and WebFOCUS may function unpredictably.
- MR Domain. This option sets IBIF_dbapass_src to the value of the IBIMR_domain variable. IBIMR_domain is the WFS variable that holds the domain href of the current action. The domain href is normally in the form of an eight character domain directory name, a slash, and an eight character domain file name followed by an extension (for example, domainon/domainon.htm or untitled/untitled.htm). Only the file name portion of the href (without preceding directory name or the extension) is sent to the WebFOCUS Reporting Server as the DBA password. A domain href of untitled/untitled.htm produces a DBA password of untitled.
-
WebFOCUS Variable. If
you choose this option, an edit box opens so that you can enter
the name of a user-specified variable available to the CGI/Servlet WFS
script processor. This value is retrieved and sent to the WebFOCUS Reporting Server as the DBA password. If the value is
greater than eight characters, WebFOCUS may function unpredictably. Use
this option if you do want to set the DBA password to a value other
than OFF, MR Id, or MR Domain (for example, you can write a WebFOCUS plug-in that decides the value).
Note: An alternative method to the MR id setting, which avoids this conversion process and sends the Managed Reporting ID as the value for IBIF_dbapass_src for DBA, is to select the WebFOCUS Variable option and add the IBIMR_ user as the variable. This will send the Managed Reporting Userid, which maximum length is 128 characters.