Examples of user authorization

This example shows the property settings to configure a database to support:

The following example shows the settings to configure a database to support:

The example also demonstrates the use of delimited identifiers for user names.

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
    'derby.database.defaultConnectionMode',
    'noAccess')

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
    'derby.database.fullAccessUsers', '"Fred!"')

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
    'derby.database.readOnlyAccessUsers', 'mary,guest')
Related concepts
Setting user authorization
Related reference
Read-only and full access permissions