Skip to Content
Author's profile photo Pradeep Gali

How to handle SOX audit systems during the upgrade

Generally Production Systems come under SOX audit and in some cases Test/Quality Systems.

During the upgrade you will be prompted to provide the DB SYSTEM USER ID and Password.  You have to plan this with help of the DBA’s otherwise you will not be able to move beyond the configuration phase untill you fix the issue.

As you can see in the below screen Shot it says ” Enter a valid DB systems user which has the “CREATE USER” privilege even though you give the correct ID and password it keeps giving the same message .

/wp-content/uploads/2013/11/config_324812.jpg

Please check the trouble ticket logs or log SHDUSRCRE.LOG in the upgrade directory ( /usr/sap/<SID>/SUM/abap/log) . This will give you the reason for this.

Brerror.jpg

Main reason is Password verification check will be maintained in the database for all the accounts.

For Example  let us take SYSTEM user account. This account will have a parameter called “profile” set to “DEFAULT”. 

System.jpg

The DEFAULT profile in turn will have a parameter “password vefiy function” set to “VERIFY”.

This is set for all the SOX audit system accounts at database level. Hence you will get the above error message.

DBA’s should set the parameter “password verify function” to “NULL” to disable the check so that upgrade can continue but after the upgrade set the parameter back to the way it should be to allow SOX audit.

/wp-content/uploads/2013/11/dba_326975.jpg

This needs to be documented for audit purpose.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.