Deleting user SAP* in SQL

[Former Member]

Hi

well i am having some difficulties, i need to delete the user sap* from an SQL Database, i know that i must execute the following command delete from usr02 where bname='sap*' and mandt='xxx'

my question to you is where to i execute this query? do i use the query analyzer? or i execute it from somewhere else? please do provide the instructions of how to go about this in SQL

I am more used to using Oracle

[Former Member]

Hi Juan,

I have deleted it directly from the table and it has worked, but which script do i run?

[JPReyes]

Hi trevor,

the command in sql is, <b><i>delete from usr02 where mandt='000' and bname='SAP*';</i></b>

The you should be log in client 000 with "sap*/pass"

Regards

Juan

Please reward with points if helpful

[JPReyes]

Hi trevor,

You can run queries directly from the Enterprise manager

Regards

Juan