One of the user authorization properties. Specifies a list of users to which full (read-write) access to a database is granted. The list consists of user names separated by commas. Do not put spaces after commas.
When set as a system property, specifies a list of users for which full access to all the databases in the system is granted.
See also derby.database.readOnlyAccessUsers.
A malformed list of user names raises an exception. Do not specify a user both with this property and in derby.database.readOnlyAccessUsers.
For more information about user authorization, see "User authorizations" in the Derby Developer's Guide.
-- database-level property
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.database.fullAccessUsers',
'commaSeparatedlistOfUsers')
-- database-level property
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.database.fullAccessUsers', 'dba,fred,peter')
--system-level property
derby.database.fullAccessUsers=dba,fred,peter
Dynamic. Current connections are not affected, but all future connections are affected. For information about dynamic changes to properties, see Dynamic and static properties.