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 DoeAbbreviation: 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.