Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

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. 

Excerpt
SQL Secure tells you who has access to what on your SQL Server databases. Learn more > >