StrataFrame Forum » StrataFrame Application Framework - V1 » Role Based Security » Retrive Data from us_Data (SFSUsers)

Retrive Data from us_Data (SFSUsers)

Malcon M. Mikami — Wed, 21 Jan 2009 11:41:53 GMT

How can I recover data from the field us_data the table SFSUsers?
As I understand it, the field us_data, has the password, the history of passwords, where he is administrator, account is active and so forth.
Is there a method that returns this information?
If there are, some other member of the forum has done some function for that?

Como posso recuperar os dados do campo us_data da tabela SFSUsers?
Pelo que entendi, o campo us_data, possue a senha, o histórico de senhas, se ele é administrador, conta está ativa, etc.
Há algum metodo que retorne esta informação?
Caso não haja, algum outro membro do forum já fez alguma função para isso?

RE: Retrive Data from us_Data (SFSUsers)

Malcon M. Mikami — Wed, 21 Jan 2009 11:41:53 GMT

OK, tanks.

RE: Retrive Data from us_Data (SFSUsers)

Greg McGuffey — Wed, 21 Jan 2009 11:22:10 GMT

Malcon,

All of that data is available via the SFSUsersBO, via the [i]us_XXX[/i] properties. If you need this data, just load the BO for a user via the FillByPrimaryKey() method then you will have access to it (there are several other FillBy methods too).

Also, the user user PK (use this to load SFSUsersBO for a user), user name and flag if the user is an administrator are available for the current user (SecurityBasics.CurrentUser), via the UserPK, UserName and IsAdministrator properties, respectively.

As Trent said, I'd be careful about getting this data directly from the us_data field. If SF changes anything within this table (like the structure or how they encrypt it), for whatever reason, any code you have will likely break. Be sure to comment these sort of changes so you can find them easily!

RE: Retrive Data from us_Data (SFSUsers)

Trent L. Taylor — Wed, 21 Jan 2009 07:36:16 GMT

You are welcome to look at the SF source code, this is why you get the source with an active subscription. But this is not intended to be broken apart. It is encrypted so as not to be dismantled or compromised. If you have this desire, then you are going to need to look at the SFSUsersBO source and start at the us_Data field and go from there. That would be my only suggestion at this point.