topic Re: Create table containing hidden (*****) password in Application Development and Automation Discussions

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

Former Member — Fri, 01 Jul 2005 09:38:45 GMT

Hello.

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

MIKE

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

Former Member — Fri, 01 Jul 2005 09:42:31 GMT

Hi Mike,

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

Regards,

Anand Mandalika.

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

andreas_mann3 — Fri, 01 Jul 2005 09:46:26 GMT

Hi Mike,

compare table usr02 field bcode

regards Andreas

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

Former Member — Fri, 01 Jul 2005 09:56:32 GMT

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.

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

Former Member — Fri, 01 Jul 2005 10:00:36 GMT

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

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

Former Member — Fri, 01 Jul 2005 10:07:18 GMT

Sorry Anans,

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

Best regards,

Alexander

Message was edited by: Alexander Webster

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

Former Member — Fri, 01 Jul 2005 10:08:25 GMT

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

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

Former Member — Fri, 01 Jul 2005 10:11:36 GMT

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 '****'.

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

Former Member — Fri, 01 Jul 2005 12:02:00 GMT

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.