Access Using Database Tools

We offer our own tools for database access, including the Computing Center Management System (CCMS).

If suitable for the task you want to perform, we strongly recommend that you use SAP tools for database access. Check the SAP documentation for your database to find out about such tools.

However, it is possible to use other applications and tools for database access. If you decide to use such tools, make sure that you are aware of the implications, as described below.

Direct Access Using External Applications

Certain external applications use the SAP SQL interface or the Open Database Connectivity (ODBC) interface to connect directly to the database.

For security reasons, use SAP tools whenever possible to access the database instead of tools based on external applications.

If you do decide to use such tools, we advise you to take the following precautions:

·        Do not use the user SAPR3 to connect to the database. Create other users for such purposes.

·        Restrict their access rights to the necessary tables only.

·        Assign read access only to these users.

If you do allow direct access to the database, make sure that you do not damage the consistency or authorization security of your database. SAP tools help you to guarantee the data consistency mechanisms and authorization concept in SAP systems.