The derby.database.readOnlyAccessUsers property, one of the user authorization properties, specifies a list of users to which read-only access to a database is granted.
The list consists of user names separated by commas. Do not put spaces after the commas.
When set as a system property, specifies a list of users for which read-only access to all the databases in the system is granted.
A malformed list of user names raises an exception. Do not specify a user both in this property and in derby.database.fullAccessUsers.
-- database-level property
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.database.readOnlyAccessUsers',
'commaSeparatedListOfUsers')
-- database-level property CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'derby.database.readOnlyAccessUsers', 'ralph,guest') -- system-level property derby.database.readOnlyAccessUsers=ralph,guest
Dynamic. Current connection is not affected, but all future connections are affected. For information about dynamic changes to properties, see Dynamic and static properties.