sap* user delete in oracle db

[manoj_nayak2]

hi,

can i delete sap* user in oracle? if yes then how?

Regards

Manoj

Edited by: manoj nayak on Jan 9, 2009 2:43 PM

[former_member682089 · Accepted solution]

Manoj,

To delete SAP* use the following command at oracle level.

sqlplus "/as sysdba"

select bname,status from rom <schema>.usr02

where bname like 'SAP*' and mandt ='<client No.>';

This will display the line which will be deleted by the following coomand

delete from <schema>.usr02

where bname like 'SAP*' and mandt ='<client No.>';

Regards,

Sandeep

[manoj_nayak2 · Accepted solution]

Hi

can u tell me how can i delete SAP* user in MS- SQL level.

manoj

[Former Member]

You can deleted but it will be created again unless you set SAP parameter

(login/no_automatic_user_sapstar) set to 1.

This can prevent user SAP* to be recreated again after you deleted from SAP user list.

Thanks

Rhishabh

[Former Member]

Hi!

Please think carefully about what you're doing here. If for whatever reason you need to 'lose' the SAP* user the best procedure is usually to rename it rather than delete it on DB level, so that you can reverse the change later. Please keep in mind also that the table USR02 can be modified in the DB, but that this change will not be known to the running SAP system if you don't take additional actions if your SAP release is 6.20 or higher.

Kind regards,

Jörg

[Former Member]

Hi!

Basically you can delete the user on Oracle level, but this is definitely not the best choice...what's behind the idea of deleting the user? Did you lose it's password or are you considering its existance a security hole (which is not the case if you set a proper password)?

Please elaborate so that we can help.

Kind regards,

Jörg

[Former Member]

hi manoj,

User SAP* is hard-coded on SAP kernel. It cannot be deleted.

You can deleted but it will be created again unless you set SAP parameter (login/no_automatic_user_sapstar) set to 1.

This can prevent user SAP* to be recreated again after you deleted from SAP user list.

ardhian

http://ardhian.kioslinux.com

http://sapbasis.wordpress.com

[Former Member]

Check

http://searchsap.techtarget.com/generic/0,295582,sid21_gci1167358,00.html