Delete sap*

[Former Member]

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??

[Former Member]

Solved

[Former Member]

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

[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??

[Former Member]

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

[Former Member]

Thanks Nil..But 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??

[JPReyes]

Why are you concern about deleting the user with sysdba?... Any user that has enough rights to delete the entry in the table will do.

Regards

Juan

[Former Member]

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??

[ImtiazKaredia]

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

[Former Member]

Hello Boss,

I am not able to login to 000 client so how I will execute su01??My ddic is locked in 000 client.

[mvoros]

Hi,

so you don't know password for SAP* but you want to log on. Do you have any other development account which can you use? You need to delete a corresponding line in USR02. You can write simple SQL query which will be client specific. Btw it's really easy to find a [solution|http://www.sap-basis-abap.com/bc/forgot-password-for-user-id-sap-in-client-000.htm] for your problem on the Internet

Cheers