Checking access rights setup in SAP BusinessObjects can be challenging. You need to click on each item in the CMC to check the configuration. This process can lead to incorrect setups, a lack of security overview, and potential security issues. Security Exporter simplifies this by allowing you to easily extract the security configuration into an Excel format.
Output
The output is an Excel workbook with the following sheets:
- Explicit Principals
- Explicit Access Levels
- Explicit Rights
- Effective Principals
- Effective Access Levels
- Effective Rights
- Access Levels Setup
If the output format is txt, results will be saved in text files with corresponding names.
Assigned Access Levels
Assigned Rights
Assigned Principals
Access Levels Setup
Queries
You can configure the scope of extraction in the queries file.
Security is usually configured on public folders, and this is typically the main focus of analysis. Therefore the default query is:
SELECT TOP 100000 *
FROM CI_INFOOBJECTS
WHERE SI_ANCESTOR = 23 AND SI_KIND='Folder'
This query extracts all CMS objects of type ‘Folder’ that are subfolders of the root Public Folder with ID 23. By default, BO CMS queries return a maximum of 1000 objects. Therefore, we need to modify the query with the TOP option in case there are more than 1000 folders.
You can change or add more queries. Each query should be on a separate line. Empty lines will be ignored. Comments start with #.
Prerequisite
You need to have SAP BusinessObjects 4.x or 2025 Client Tools on your machine.
Information
Downloads
Without a PRO license the tool runs in a limited test mode — you can retrieve and browse the security. A PRO license is required to export to Excel/CSV and to automate with the CLI.
