Page History
IDERA SQL Secure includes the ability to take the existing built-in SQL Secure reports and seamlessly integrate them into Microsoft Reporting Services. For each built-in SQL Secure report, the Deploy Reports wizard installs a Report Definition Language (RDL) file. These RDL files define the report layout and parameters, using the data source (SQL Secure Repository) you specified during install. Reporting Services automatically acknowledges these files, allowing you to immediately generate and view reports on audit data using the Reports Manager Web interface.
...
Assessing the appropriate role on the SQL Secure folder in Report Manager, the individual report files inherit the permissions you set. By default, the Deploy Reports Wizard writes the report files to the C:\Program Files\IderaSQLsecure\Reports folder on the Report Server computer.
| Account | Action | Requirement |
|---|---|---|
| Logon account used for install | Write RDL files to the Report server computer and configure reports | Write access to the Report Server file system and Content Manager role |
| Proxy user | Connect to the Repository and read data per report parameters | Read access to the Repository databases |
| Administrator | Configure reports and set security | Content Manager role |
| End user (auditor or manager) | Generate and view audit reports | Browse role |
Install reports
The Deploy Reports wizard allows you to specify the proxy user account credentials and deploy the reports. Perform this deployment for each Repository that contains data you want to audit using Reports. Once installed, click the View Deployed Reports link at the bottom of the SQL Secure Reports window to find your reports.
...
To grant auditors the ability to view and generate reports, create a SQL Server login and grant the Can view and Report on audit data permissions. Ensure that this account has the Browse role on the root folder.
SQL Secure tells you who has access to what on your SQL Server databases. Learn more > >
...
...