Cloudsync Properties
Page 5 of 17

cloudscape.database.sourceUser

Function

The cloudscape.database.sourceUser property assigns a user ID to targets for JDBC authentication at the source during a refresh. This property is one of a number of means of providing targets a valid user name at the source for situations in which the source is configured for user authentication. For more information, see Chapter 5, "Refresh Authentication".

This property can be set at either the target or the source. When set at the source, the name is not visible to targets and is appropriate for systems in which targets are deployed outside the firewall. When set at the target (either directly at the target or as a published property) the name is visible to targets and is appropriate only for inside-the-firewall systems.

When a refresh applies target transactions to the source, the SQL-J CURRENT_USER and SESSION_USER expressions evaluate to the connected source user.

NEW: The ability to set this property at the source is new in 3.6.

Syntax

For sources:

CALL PROPERTYINFO.setDatabaseProperty(
    propertyName, value)

For targets:

cloudscape.database.sourceUser=value

or

CREATE PUBLICATION pubname
...
ADD TARGET DATABASE PROPERTY
    cloudscape.database.sourceUser=value

Example

CALL PROPERTYINFO.setDatabaseProperty(
    'cloudscape.database.sourceUser','refreshUser')

Scope

Database-wide, system wide.