How Can the use of the SQL editor in DBACOCKPIT be controlled?

Updated May 18, 2018

Hello Experts,

May I know that how can the use of the SQL editor in DBACOCKPIT be controlled?

Kindly share your valuable views here.

Thanks in advance.

Comments

20 Jan 2016 5:00 pm Abhijeet Mudgal Best Answer

The SQL editor allows to flexibly executes SQL statements for analysis purposes, e.g. SQL statements provided via SAP Note 1969700. This is particularly helpful when SAP expert services like the "SAP Technical Performance Optimization Service - HANA" (SAP Note 2177604) are delivered.

In order to be able to perform an efficient analysis, authorizations for the following authorization objects are needed:

S_DBCON
S_RZL_ADM

The setting of S_DBCON is particularly important for the SQL editor permissions. It depends on the SAP basis patch level and is changed as of SAP_BASIS 7.40 SP14 and SAP_BASIS 7.50 SP01 (see SAP Note 1933254):

ACTVT	Description	Original layout	New layout (SAP Note 1933254)
03	Display	The SQL editor is disabled.	The SQL editor is enabled, but only works for tables with explicitly activated table-level authorization.
23	Maintain	The SQL editor is enabled for SELECT statements.	-
36	Extended	The SQL editor is enabled for all types of SQL statements.	The SQL editor is enabled for all types of SQL statements.

For root cause analysis and TPO service deliveries a S_DBCON level of at least 23 (original layout) or 03 with accesses to at least SYS and _SYS* tables (new layout) is required.