topic Re: authentication table in Application Development and Automation Discussions

authentication table

DKarthick — Wed, 01 Apr 2020 09:41:26 GMT

hi,i am doing a project which invovles sap as backend and angular as frontend.i made a login form which needs to be authenticated in the backend sap.to do so i have to create a zlogin table which holds userid and password.in which the userid needs to be string as well as primary key.but i cant use string as a primary key.what should i do??

Re: authentication table

Former Member — Wed, 01 Apr 2020 10:23:14 GMT

You do not need to manage user id an password service-wise, it is taken care by the SAP system.

Access restriction should be achieved via authorization check.

Re: authentication table

Sandra_Rossi — Wed, 01 Apr 2020 12:28:05 GMT

Storing the password in plain text or the password hash?

User ID has probably a limited length, you then don't need String.

Re: authentication table

former_member317614 — Wed, 01 Apr 2020 19:33:59 GMT

In ABAP tables string type is CLOB.

So to store user name use CHAR with fixed max length.

P.S. is it "legal" to use single user as background user to authentificate with some Z-code ?