Skip to Content
author's profile photo Former Member
Former Member

DB Parameter maintenance in Managed System configuration

Hi All,

We are configuring the managed system in solution manager. Found that the schema username/password needs to be used for the DB parameter maintenance. Can we create an user account on the database to avoid using the schema credentials? If so, what should be the privileges for the account. This is required to meet the audit standards. Please advice on possibilities.

Thanks,

Magesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 04, 2014 at 11:33 PM

    Hello

    I believe you are establishing a connection to an Oracle database used by an SAP system. In that case read this SAP note 1261329 - DBA Cockpit: Oracle as a remote database

    2. Connect user

    The database user who is to be entered for the database connection can be the relevant schema owner, in other words, SAPR3, SAP<SID>, SAPSR3, or SAPDB<SID>. In MCOD systems, you must select the database user who is the owner of tables SDBAH and SDBAD and to which the public synonyms SAP_SDBAH and SAP_SDBAD point.

    If the use of the SAP schema user is not possible, you can also use a different user. The SAPDBA role (see SAP Note 134592) must have been assigned to this different user.

    Reagan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.