New attribute in System/User table 

New attribute in System/User table 

  

I want a new dimensions for my users (system/user table) to store an abbreviation for the user, which I can use throughout my application. 


Eg:
Name: john Doe
Abbreviation: JD


But i see it's not possible to add an attribute to the System/User table... What will be the way forward to get this done? And any suggestions on how to create this abbreviation manually?

It should be a global attribute that can be used throughout the application (over several modules).

Imho the approach would be:

Create an Entity "ExtendedUser" with UserID as PK and you are done.

expose it and when creating a user, wrap it to create a user inlcduing the extended user.