How To Fix DDIC_ADT_DDLS035 - DDL &1 generated by DCL activ.; can only be changed by corresponding DCL

SAP Error Message - Details

• Message type: E = Error

• Message class: DDIC_ADT_DDLS - ADT DDL Source Editor

• Message number: 035

• Message text: DDL &1 generated by DCL activ.; can only be changed by corresponding DCL

What causes this issue?

This DDL &V1& was generated by activating a DCL. Such DDLs can not be
changed directly by the DDL editor in ADT.

System Response

No lock was granted for this DDL file &V1& to prohibit any change.

How to fix this error?

This DDL may only change when the corresponding DCL is changed.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DDIC_ADT_DDLS035 - DDL &1 generated by DCL activ.; can only be changed by corresponding DCL ?

  The SAP error message DDIC_ADT_DDLS035 typically indicates that there is an issue related to the Data Definition Language (DDL) and the Data Control Language (DCL) in the context of database objects. This error occurs when you attempt to change a database object that is controlled by a DCL, which restricts modifications to the object unless certain conditions are met.
  Cause:
  The error message is triggered when:
  
  You are trying to modify a database object (like a table or view) that has been defined with specific access controls (DCL).
  The DCL settings prevent changes to the object unless you have the appropriate permissions or are following the correct procedures to modify it.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Check DCL Settings: Review the DCL settings associated with the database object you are trying to modify. Ensure that you have the necessary permissions to make changes.
  
  
  Use the Correct Transaction: If you are using a transaction or tool to modify the object, ensure that you are using the correct one that respects the DCL settings.
  
  
  Consult with Basis or Security Team: If you do not have the necessary permissions, you may need to consult with your SAP Basis or Security team to either gain the required access or to have them make the changes for you.
  
  
  Review Documentation: Check the SAP documentation or notes related to DCL and DDL to understand the specific requirements and restrictions that apply to the object you are working with.
  
  
  Use the Correct Development Environment: Ensure that you are working in the correct development environment (e.g., development, quality assurance, or production) and that you are following the proper change management processes.
  
  
  Related Information:
  
  DCL (Data Control Language): This is a subset of SQL used to control access to data in a database. It includes commands like GRANT and REVOKE, which manage user permissions.
  DDL (Data Definition Language): This refers to the SQL commands used to define and modify database structures, such as CREATE, ALTER, and DROP.
  SAP Notes: Check SAP Notes for any specific patches or updates related to this error message, as SAP frequently updates its knowledge base with solutions for common issues.
  
  If the problem persists after following these steps, consider reaching out to SAP support for further assistance.