Create table containing hidden (*****) password

[Former Member]

Hello.

How to create a table with a column 'password', whereas the contents of this field should be hidden (*******) in SE16?

MIKE

[Former Member]

Hi Mike,

Make the field of type RAW. Such fields cannot be displayed on the screen.

Regards,

Anand Mandalika.

[Former Member]

I'm sorry. Try to have a non-key field for your password and make its type LRAW. The table should also have a field of type INT2, which immediately precedes the LRAW field.

This will be a cluster table , similar to INDX etc.,

This is just a technical solution to your question. You must think if it really makes much sense in your context to use this approach.

It might be better to have a field which can be displayed, but which stores the password in an encrypted format. There are function modules available to encrypt strings.

Regards,

Anand Mandalika.

[Former Member]

Hi,

I just checked this by looking at USR02 in SE16, but I could see the entry in the RAW field.

In this case the value was DB708A745ADE2E8A, but that is because the value is hashed. If the program putting the password in USR02 did not hash it I probably would have seen the password itself.

I do know that sometimes not all of the data is displayed in SE16 but imho that is normally the case with fields that are very long ( raw 256, etc.)

Sorry I don't have an answer to the problem, but I do believe that using a raw is not the answer. Mayb you can copy the routine used by SAP to create the one way hash.

Best regards,

Alexander

[Former Member]

Sorry Anans,

Looks like I writing post at the same time as you.

Best regards,

Alexander

Message was edited by: Alexander Webster

[Former Member]

Hi,

You might as well check the FMs FIEB_PASSWORD_ENCRYPT

FIEB_PASSWORD_DECRYPT. So, the data eventhough visible in SE16 is not of much use.

Does it help?

Thanks, Debasish

[Former Member]

Thanks for your postings, but ... that´s clear so far.

Backgound: I found a table GRMG_PROPERTIES which contains a field, that CAN contain such a password, depending on the contents of the preceeding field ... If this is 'PW' the succeeding field is shown with '****'.

[Former Member]

Hi Mike,

It would have been desirable to have this information in your initial posting itself. That would help the guys answering your question to give you a more appropriate answer.

Regards,

Anand Mandalika.

[andreas_mann3]

Hi Mike,

compare table usr02 field bcode

regards Andreas