TempTablesAtOwner

The TempTablesAtOwner Rules Engine property can be used to override the Temp_Table_At_Owner deployment parameter setting for the current deployment context and for the duration of the current session.

You can set deployment parameters in USoft Authorizer for 3 different deployment contexts: Client/Server, RunBatch, and Rules Service. See the Authorizer Guide. One way to access the Authorizer Guide is to press CTRL + F1 in USoft Authorizer.

This setting allows you to specify that temporary tables are to be created in the owner's schema.

Setting this property

You can reset this property by executing:

SELECT RulesEngine.SetProperty( 'TempTablesAtOwner', 'value' )

value ::= { Yes | No }

This entire statement is case-insensitive, including the property name and the values of value. 'No' is the USoft factory default, meaning that the Temp_Table_At_Owner deployment parameter is set to 'False' by default.

Getting this property

You can get the current value of this property by executing:

SELECT RulesEngine.GetProperty( 'TempTablesAtOwner' )

This entire statement is case-insensitive, including the property name.