Changing Users Logons

Question: Does anyone know how we can change the logon id of a user. Our IDs are based first 6 digits of the surname and the first inital. We want to be able to change the logon at the request of the user (eg marriage) to reflect a new surname. Worried that this will have an impact on the users in the Org Structure for EBP.

Any info greatly appreciated.

Answer:
Basic SQL 101
They key field of a table cannot be changed. You can copy the entry, create a new key and delete the old entry but all the relationships die. The only way to get around it is to know all the relationships and program like crazy to keep all the relationsps constant. There are tons of things to consider thata re linked to the user name.

1. variants
2. user specific line layout variants
3. relationships of user id to personnel number (this is huge)
4. user specific data extracts in CO etc.
5. spool data
6. inboxes
7. user settings in many of the modules of SAP
etc. etc.

The best systems will base the user id on something fairly constant like a personnel number. Then names can change forever but the user id can stay the same. But even this isn't a panacea. Audit trails really are harder to trace without a mnemonic id.

Answer:
If it is a manageable amount of users, take Su01 and copy the user account, rename, set new password, delete old user...

If the user is a developer or the likes, you will need to check other keys, and as a cautionary measure search for the user name string in ABAP.

If you find it...

Answer:
If it is a manageable amount of users, take Su01 and copy the user account, rename, set new password, delete old user...

If the user is a developer or the likes, you will need to check other keys, and as a cautionary measure search for the user name string in ABAP.

If you find it...

And if you do give them a bollocking!

Answer:
Why do not change the policy? Its not so difficult than hack the system.

For example we use the employee reference number to generate the user name. Or you can set up a simple counter to generate the name of new users.

BTW: our company policy is that the 3rd party users name is compiled from the company name and a counter. Its good because you look at user list and you know who is allowed to work and who is not. The problem occures when a consultant changes his company but still support us.

Regards,

Zav

Answer:
Why not just use the 'rename' function ? User will require a new initial password and you'll need to change the address details, but that's not a hardship - far as I can see it's a bit better than copying the user only?
_________________
Regards.
ib
_________________________________
SAPFans help those who help themselves !

Answer:
For example we use the employee reference number to generate the user name. Or you can set up a simple counter to generate the name of new users.

This would also make the programable parts of tools much faster and the 300 trillion password options to compare no longer necessary. Can you send me your system's IP address?