derby.database.fullAccessUsers The derby.database.fullAccessUsers property, one of the user authorization properties, specifies a list of users to which full (read-write) access to a database is granted. derby.database.fullAccessUsers property User authorizationconfiguring

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 full 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 with this property and in derby.database.readOnlyAccessUsers.

User names, called authorization identifiers, follow the rules of SQLIdentifiers and can be delimited. Specifying a user name that does not follow these rules raises an exception.

For more information about user authorization, see "Configuring user authorization" in the .

Syntax -- database-level property CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'derby.database.fullAccessUsers', 'commaSeparatedlistOfUsers') Example -- 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 or static

Dynamic. Current connections are not affected, but all future connections are affected. For information about dynamic changes to properties, see .