Hello,

We are trying to implement a logging mechanism over the Strataframe RBS. We have written triggers on the RBS tables and in order to pass application values (like the username) to the triggers we are setting the context_info variable of StrataFrame.

In program.cs:

sSql = "declare @context_info varbinary(50);set @context_info = cast('" + MicroFour.StrataFrame.Security.SecurityBasics.CurrentUser.UserPK.ToString();

sSql +="@" + sFullIP + "' as varbinary(50));set context_info @context_info;";

DataLayer.DataSources["MySecurityKey"].ExecuteNonQuery(sSql);

We used SQL Server profiler and saw that context_info is properly set with this command.

When the program loads and I click on the security editor a number of SQL statements are executes with sp_reset and the context_info variable is also cleared.

We would like to find a method so that context_info is not cleared and our triggers use this information for logging.

Could you please help us?

On the client side?

Yes.