cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete user SAP* from database in MaxDB

Former Member
0 Kudos

I´m unable to login with user SAP* into client 000 but in other clients.

How can I delete the user SAP* from client 000 that I can login with the standard password?

Is it possible within a transaction in another client or only on DB?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188883
Active Contributor
0 Kudos

Hi Damian,

You need to connect to MaxDB SQL studio using user SuperDBA,admin

Run the following commands

select bname from <SAPSCHEMA>.USER02 where bname='SAP' and MANDT='000;*

This will list user SAP* from client 000

delete from <SAPSCHEMA>.USR02 where bname='SAP' and MANDT='000';*

This will delete SAP* from client 000.

Regards,

Deepak Kori