Kbase 14015: How Report Builder works with security
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How Report Builder works with security
INTRODUCTION:
=============
Understanding how Report Builder stores security information and how
to work with it.
WHY YOU NEED TO KNOW THIS:
===========================
To understand how to work with the Report Builder, or Report Engine
when using security specified at the database level. Report Builder
itself DOES NOT contain a security module.
PROCEDURAL APPROACH:
====================
Report Builder stores information in the report definition file. A
logical flag representing the presence of a password is stored when
the last saved connection was made. The password is NEVER stored.
If the logical flag is TRUE, then Report Builder prompts the user with
an identification dialog when opening the report. The dialog contains
userid and password edit boxes.
If the logical flag is FALSE, then the Report Builder assumes that it
can connect to the database without any userid/password information.
If a user has a userid, with no password specified, the logical flag
will be set to FALSE, and no identification dialog will appear when
opening the report.
If the database security changes so that a user now requires a
userid/password, but didn't at the time that the report was created
and last saved, the following will occur:
Using Report Builder: the user would be prompted to correct the
connection information. Once the information
is corrected and the report is saved, the
changes are permanent.
Using Report Engine: an error would occur and the Report Engine
would terminate.
One of the following can also be done to correct the userid in the
connection information saved in the Report Builder report definition
file:
(1) Use the Open, Report, Copy option to make a copy of the report
to another library, specifying the userid and password in the
connection information for the copy.
(2) Set the Options, Preferences, Always Prompt so that Report
Builder will prompt for connection information when opening the
report.
(3) If using the Report Engine, specify the -U and -P parameters
in the RB-DB-CONNECTION parameters.
Progress Software Technical Support Note # 14015