Hello

What is the best way to extend the SFSUser Table to add custom user fields (eg. EmployeeID, Title, Phone Numbers)

Thanks

------------------------------------------------------------------------
I would like to change the world, but they don´t give me the source code.
MS Windows 7 Ultimate 64-Bit
Intel(R) Core(TM)2 Quad CPU Q9300 2.50 GHz
6.00 GB of RAM, NVIDIA GeForce 9800 GT

MacBook Pro i5 OSX Lion

You best bet would probably be to add table to your database to store that information and tie the records to the SFSUsers table through the us_pk field.  Then, you would just need to create a business object for that table and a form to allow the information to be edited/maintained.

I don’t know what others are doing, but as Ben suggests, I started out by adding a table to the data base to hold the additional user fields that contained a foreign key from SFSuser.  As Ben would probably not recommend, I modified the SF user maintenance dialog by adding a tab to maintain the added info along with a BO that mapped to my new table. It looked and worked great, however keeping my version of Role Based Security in sync the SF release quickly got old. I ended up building my own “Additional User Info” maintenance screen that has the same look and feel of the SF user maintenance dialog. On my main form I have a User maintenance menu with “Security” and “User Info” sub menus to bring up the proper dialog.

 

I also added some logic to AppMain that checks to make sure the additional user info fields are populated when the user logs in and exposes those fields via public properties of a static class.  

 

-Larry

Thanks for the advices

I was thinking of two approaches:



1) Creating a separate security assembly that contains the custom field depending on client request (I did it similar when enhacing the inherited ui assembly for a third party control suite not supported) it will be easier to maintain between StrataFrame releases.



2) The approach of creating another table at application level.



what do you think?

------------------------------------------------------------------------
I would like to change the world, but they don´t give me the source code.
MS Windows 7 Ultimate 64-Bit
Intel(R) Core(TM)2 Quad CPU Q9300 2.50 GHz
6.00 GB of RAM, NVIDIA GeForce 9800 GT

MacBook Pro i5 OSX Lion