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
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.