Use SAP's OpenSQL Tool to Close Your SAP Access Control 5.3 Reporting Gap

  • by John Stephens, Senior SAP Security Consultant, Hermosa Beach Consulting Group
  • February 26, 2013
Learn how to use SAP’s OpenSQL Tool for SAP Access Control 5.3 to provide the right people with key information that is currently not available in the application itself.
Key Concept

The SAP OpenSQL Tool for Access Control 5.3 is an interface provided to your SAP Access Control database tables that allows you to provide reporting that fills the gap between the SAP-delivered reporting and the reporting available with the connection to SAP NetWeaver Business Warehouse. SAP provides this free tool with software that connects directly into your SAP Access Control Java tables. It is already installed along with your SAP Access Control 5.3 software and is free. The tool provides the interface, a list of predefined SQL queries, a direct connection to the Java application tables, a free text area to input your own SQL queries, and results display.

By using SAP's SAP OpenSQL Tool, administrators can complement the reporting that SAP Access Control already provides. The SQL queries predefined by SAP and the examples I provide give you insight into many different areas in the system, uncovering important information, such as:

  • Who are my delinquent approvers for all my current open access requests?
  • What are my service times and approver type durations and percentages for my closed requests?
  • Which of my role approvers has the most access requests in his or her queue?

By having access to this type of reporting, administrators can optimize the system and provide key information to those who need it, when they need it. SAP provides predefined SQL queries covering most of the modules. The tool also enables you to create custom SQL queries to directly access the database tables.

John Stephens

John M. Stephens is a senior SAP security and GRC consultant with Hermosa Beach Consulting Group. He has 15 years of SAP authorizations experience and has specialized in security implementations and upgrades of SAP GRC, SAP NetWeaver BW, SAP BusinessObjects, and SAP NetWeaver Portal over the last five years. Before joining Hermosa Beach Consulting Group, he managed teams to coordinate and performed SAP security implementations and administration activities within small, midsize, and large multinational SAP environments and operated as an independent consultant, performing SAP system audits, security implementations, and redesigns across many SAP applications.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.