Kbase P101665: How to add security to a CorVu Quick report.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/14/2005 |
|
Status: Unverified
GOAL:
How to add security to a CorVu Quick report.
FIX:
There are various methods for adding security to a query, some more secure than others. CorVu 5 does actually have the possibility to use menu button security, but for CorVu 4 in most cases the security is added to the dynamart query which is used to make the Quick Report.
The suggested possibilities -
1) use a filter query with a prompt for a dummy prompt 'Password' - not very secure.
2) use a !username prompt, and filter rows based on user name - needs lot of administration to set up.
3) use Column Security - can be used to hide column if user should not be permitted access.
4) use row level security - hide all rows if user not permitted.
5) Place the QRP file in a WINNT folder, change WINNT file access rights to the folder to deny access to all but the correct WINNT users. - This is most secure.
6) Use 3-Tier filing system - place QRP into private folder of a 3-tier user - only that user will be able to run it.