Skip to Content
avatar image
Former Member

Delete sap*

Hello All,

We are using ECC 6.0,HP-Unix & Oracle 10.2 system.For deleting sap* from database level I logged in with orasid & then connected as sysdba in sqlplus.Is there any database user id for SAP BASIS other than sysdba to delete sap* from database table??Can I delete SAP* from SAPDBA User Id??

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Feb 02, 2010 at 07:33 AM

    sql>delete from SCHEMA.USR02 where BNAME = 'SAP*' and MANDT ='000';

    Change the below instance paramerer value to 0 and restart your DB+apps, login with new password PASS

    Login/no_automatic_user_sapstar

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Juan Reyes

      Juan the problem with our client is that we have a separate database group who have the full access.But our sap team do not have access to sysdba.our database owner is sapsr3.Is it posible to do all the database activities with sapsr3??Moreover backup is taken by Rman so db02 is not giving any details so how the backup details will be relected in dbo2 if we are not doing the backup through brtools??

  • Feb 01, 2010 at 08:48 PM

    Why don't you simply delete sap* user from SAP transaction su01 and set parameter login/no_automatic_user_sapstar to 1.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 02, 2010 at 06:56 AM

    Hi,

    First you can find 3rd pary backup logs under /oracle/SID/sapbackup logs or from DB12(even not scheduing from DB13)

    SAPSR3 is the schema owner not a dialog user....and sap ever/never recommends to use your schema owner for dialog logging.

    And according to your above input, you have other DB users with full access, then you can do any DB related activity with those users. Why you want to use SAPSR3?

    Any DB user with full access can do all DB activities, addition to that you can delete the SAP* user by logging with ORASID with sysdba privillages.

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Nick,

      I am posting the same thing again & again but still not answered..We have a separate database team who has the access of sysdba..tHey will not allow us to use SYSDBA..Other than this if we have any other user ID we can use..My Question is other than SYSDBA whether we can perfom the DB Activities with orasid or any other id??

  • avatar image
    Former Member
    Mar 08, 2010 at 04:19 PM

    Solved

    Add comment
    10|10000 characters needed characters exceeded