Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reportsmith 3.11 user security

Status
Not open for further replies.

dloper3

IS-IT--Management
Feb 23, 2008
1
US
Can anyone tell me if version 3.11 Reportsmith allows for different user roles - or if you can limit reports to be executed only (not edited?) I am trying to find a way to eliminate the possibility that any reportsmith user can write a report and extract more than they should from the database.

For example, giving them access to limited tables, and only a small list of reports built for them that they can execute on demand, but not alter.

Any resources out there on this topic?
 
Disable all toolbar options to prevent the user from altering the report.

1. Create a macro linked to the event 'Before Report Open'
2. Paste into macro...
EnableMenu "File",0
EnableMenu "Edit",0
EnableMenu "View",0
EnableMenu "Insert",0
EnableMenu "Format",0
EnableMenu "Tools",0
EnableMenu "Window",0
EnableMenu "Help",0

So when this report opens, the toolbar for ReportSmith will be shaded out, preventing the user adding tables/fields/columns etc. You can also disable parts of the tool bar...ie EnableMenu "File|New",0. Use this in combination with EnableIcon (ReportSmith Icons) and EnableRMenu (ReportSmith Right click events) to disable other features as well.

Always remember, if you do this, to set up a macro that will allow you to reactivate these toolbars using a PasswordBox. And do not set this macro up as Global.

Hope this helps.
 
What about pre-written reports and the run-time viewer? The reports live in a directory that only they can get into.

Specializing in ReportSmith Training and Consulting
 
It would be a combination of a couple different approaches.

As Charles mentioned, Reportsmith has a run-time viewer that installed for users who won't be developing reports and just running them. You could also have a set of reports in a folder that the user doesn't have write access to.

To limit the tables that the users can access you would use database security. This controls what tables the users are given grants to at the database level and are ultimately seen in Reportsmith. In addition, there's also department security that can limit which departments the users can see employee level data from.

The Security and Admin guide provides a good starting point for information on Database and Department Security. Please let me know if you're looking for something in more detail that what's there.


John Sakalauskas
VantageIS,LLC
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top