Purpose

You may require that the user enter a password to run a local web report.
To do so, you type a specially-formatted prompt in the WHERE clause of the SQL Statement. The password is prompted for when the report is run.

For example, assume you have a report based on the query below:

select field1 from library.table
where field3 = 'L'
fetch first 10 rows only

To password protect this report with the password "12a34", add a user prompt as follows:

select field1 from library.table
where field3 = 'L'
and '12A34' = upper('PROMPTSTART Please type the password. PROMPTEND')
fetch first 10 rows only

If you want the password to be case-sensitive, leave out the upper() command around the prompt.

Note:

The passwords described in this article are not a replacement for requiring a specific user account or role, nor are they as secure as the normal HRMS user authentication system.

However, you may choose to use them as an additional step that the user must take to access a report. Using this type of passcode is most appropriate when granting access to a report displaying sensitive, but non-personal, information to a limited set of Anonymous users to whom you will give the password.

In this case, Anonymous should be type of individual users who can access the report. ("Anonymous" is not the equivalent of "anyone" because HRMS is always secured behind your network firewall, and only persons using a computer on your network could have access to HRMS in the first place.)