You can use the derby.database.defaultConnectionMode property to specify the default type of access that users have when they connect to the database.
If you do not specify a setting for the derby.database.defaultConnectionMode property, the default access setting is fullAccess.
To set the default connection access mode, specify the access in a CALL statement. For example:
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.database.fullAccessUsers', 'sa')
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.database.defaultConnectionMode',
'readOnlyAccess')
To specify read-write access for the user ID Fred and no access for other users, issue these CALL statements:
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.database.fullAccessUsers', 'Fred')
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.database.defaultConnectionMode',
'noAccess')