StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Using User security etc

Using User security etc

Ger Cannoll — Fri, 15 Jun 2012 17:46:50 GMT

I plan to use User Logins and Roles etc in the next while and am currently seting up my Application Database tables. At this point, I am setting up the actual transaction tables (rather than the User login / roles tables etc.)

I need to know what type of fields to set up for the appication to hold the user ID. Typically I will be adding a 'Who Did what when' to my data files and need to know what type of field the 'Who' should be . What sort of field does SF expect a user to be Integer ? Character ? Varchar? etc.

Tia

Gerard

RE: Using User security etc

Ger Cannoll — Fri, 15 Jun 2012 17:46:50 GMT

Hi Edhy.

Thats great and thanks for the tips

RE: Using User security etc

Edhy Rijo — Fri, 15 Jun 2012 12:00:35 GMT

Hi Gerard,

StrataFrame holds a security object SecurityBasics.CurrentUser with some properties that could be useful for you, UserPK holds the PK (Int) field and UserName (Varchar) holds the user name, so you can use whichever fit your case. I mostly use the SecurityBasics.CurrentUser.UserName value to avoid having to look at the PK value when generating reports or showing this info on a form.

Also on a site note, check this thread http://forum.strataframe.net/FindPost14216.aspx posted by Charles Thomas Blankeship a while ago, but still very accurate on how to add security to your SF applications.