Examples of user authorization

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

Full access for a single user named "sa"

Read-only access for anyone else who connects to the database

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
    'derby.database.defaultConnectionMode',
    'readOnlyAccess')
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
    'derby.database.fullAccessUsers', 'sa')

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

Full access for a single user named "Fred!" (case-sensitive) with full (read-write) access
Read-only access for mary and guest
No access for other users

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')