<< Click to Display Table of Contents >> Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Object Permissions Report

Report Name: Object Permissions Report (example)

File Name: EarthSoft.Reports.Library.97403.dll

Dependencies: Enterprise Schema and site

Software: EQuIS Professional, EQuIS Enterprise

Source: EQuIS Professional install, EQuIS Enterprise install

Language: Arabic, English, French, German, Spanish, and Portuguese

Output Type: Excel1

 

Description: The Object Permissions Report shows the permission granted or denied on a specified object for users or roles.

 

The report consists of a Microsoft Excel workbook with multiple worksheets. The first worksheet, called "Report Info", is an overview of the report including report runtime, run by, which object the permissions are for, and what report parameters were used. The two remaining worksheets show the permissions on the object for Users and Roles, respectively. The format of the Users and Roles worksheets is similar to the permissions grid. Instead of the rows listing objects with the associated permissions, the rows list users and roles with the associated permissions for the report's specified object that use numbers rather than icons to signify permission levels:

 

 

If the user is an administrator, the report will list all users and roles. If not, the report will only list the logged-on user and any roles to which that user is a member.

 

Installation Instructions:

To enable the report in Enterprise, do the following:

1.Publish the Reports – The two reports from the EarthSoft.Reports.Library.97403.dll assembly will need to be published to the database before they will work. Publishing can be achieved with EQuIS Professional. To publish using EQuIS Professional, follow the steps on the Publish a Report - Quick-start Guide page.

2.Grant Appropriate Permissions – Once the report has been published to the EQuIS database, users who do not already have permission to view the general report type will need to have at least Viewer permission granted to them for the report. The permission must be granted to this report specifically; granting any permission to a new report created from these reports (such as a saved user report) will not enable the download link in Enterprise.

 

In Enterprise, download links with the icon appear in the final column on the permissions grid located in the following areas:

•The User Profile window, accessible to administrators in the User Manager widget.

•The Permissions section of the Role Profile window, accessible to administrators in the Role Manager widget.

•The current logged-on user's profile, accessible within the More Options icon on the right side of the dashboard header.

 

These download links are available for an object type or a single object.

 

If the report is published and the user has permission, clicking on this download link icon will run the report and download it in the browser. The report will show the permissions granted or denied to users and roles on the EQuIS Enterprise object specified in that row of the permissions grid. If the user is not an administrator and is accessing the download link from the permissions grid on that user's User Profile, the report will only show permissions on the specified object effectively granted to that user and only to roles to which that user is a member. Changes to a user’s permissions must be saved to appear in the report.

 

 

Overview:

 

 

 

Tables: ST_ROLE, ST_USER, hidden XT_AUTH… tables

 

Data Requirements: N/A

 

Report Requirements: In EQuIS Professional, it is recommended to log in as an Enterprise user to run this report; otherwise, some parameters may not be able to be set and/or the report may not output any results.

 

1Excel report output requires a valid license of Microsoft Excel to view the output.