Cloudscape Properties
Page 15 of 47

cloudscape.database.readOnlyAccessUsers

Function

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 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.

See also cloudscape.database.fullAccessUsers.

A malformed list of user names raises an exception. Do not specify a user both in this property and in cloudscape.database.fullAccessUsers.

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

Syntax

-- database-level property
CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.database.readOnlyAccessUsers',
    'commaSeparatedistOfUsers')

Example

-- database-level property
CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.database.readOnlyAccessUsers', 'ralph,guest')

-- system-level property
cloudscape.database.readOnlyAccessUsers=ralph,guest

-- publishing a database-wide property
ALTER PUBLICATION APub
ADD TARGET DATABASE PROPERTY
cloudscape.database.readOnlyAccessUsers=
    'ralph,guest'

Scope

database-wide (publishable)

system-wide

Dynamic or Static

Dynamic. Current connection is not affected, but all future connections are affected. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties.