StrataFrame Forum / StrataFrame Application Framework / Role Based Security / Custom Fields to SFSUser table / Latest Posts

RE: Custom Fields to SFSUser table

Guillermo Vilas — Tue, 16 Jan 2007 15:51:38 GMT

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?

RE: Custom Fields to SFSUser table

Larry Caylor — Tue, 16 Jan 2007 12:22:30 GMT

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

RE: Custom Fields to SFSUser table

Ben Chase — Tue, 16 Jan 2007 12:03:55 GMT

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.

Custom Fields to SFSUser table

Guillermo Vilas — Tue, 16 Jan 2007 09:51:41 GMT

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