Oracle SQL Forum
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.
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:
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):
The SQL editor is disabled.
The SQL editor is enabled, but only works for tables with explicitly activated table-level authorization.
The SQL editor is enabled for SELECT 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.
Sign up for STechies
Ask Question From Our Experts