Configuring database options

To configure the database options for a group or user:

1. Click Users/Group in the Host On-Demand Administration window.
2. Right-click the group or user and click Database > Options.

You can configure database options to specify the behavior of Database On-Demand for a specific user or group of users. Some of the options allow or restrict certain functions; other options set default values.

When options are modified for a selected group, all users in that group inherit those settings. Database On Demand provides the following two methodologies for granting users authority for options:

• Most permissive
  If a user belongs to two or more groups, the most permissive authority is granted for that option.
  
  For example, if a user is a member of group1 and group1 allows deleting SQL statements, and the user is a member of group2 but group2 does not allow deleting SQL statements, the user is allowed to delete SQL statements.



• User override
  When options are modified for a selected user by either the user or an administrator, the new settings override settings for the group or groups to which the user may belong. Default user options (those not explicitly set by a user or administrator) do not override group settings. This gives the administrator the ability to allow or restrict certain functions at the user level.
  
  For example, suppose a user belongs to group1 which allows edit SQL statements, and group2 which does not allow edit SQL statements, and the user level options do not allow edit SQL statements. The user cannot edit SQL statements, even though group1 allows it.

The table below details how user authority for options is granted.

Individual options are grouped into the following categories:

• General
• Statements
• Tables
• Drivers
• User Options

General

• Allow creating SQL or File Upload Statements
  Allows you to create new SQL or File Upload statements.

• Allow saving SQL or File Upload Statements
  Allows you to save SQL or File Upload statements that you create or modify. This option is valid only if Allow creating SQL Statements or File Upload statements is selected.

• Allow deleting SQL or File Upload statements
  Allows you to delete previously saved SQL or File Upload statements. You can delete only your own saved SQL or File Upload statements.
• Allow manual editing of SQL statements
  Allows you to manually edit the generated SQL statement prior to saving it.
• SQL query timeout
  Used as a timeout value when executing an SQL statement. Choose a number between 0 and 3600 seconds. Choose 0 for no timeout.

Statements

SQL statements

• Allow select statements
  Allows you to generate statements that use the SQL select clause
• Allow select unique statements
  Allows you to generate statements that use the SQL Select Unique clause
• Allow insert statements
  Allows you to generate statements that use the SQL Insert clause
• Allow delete statements
  Allows you to generate statements that use the SQL Delete clause
• Allow update statements
  Allows you to generate statements that use the SQL Update clause

File Upload statements

• Allow Create statements
  Allows you to generate statements that use the File Upload type create
• Allow Replace statements
  Allows you to generate statements that use the File Upload type replace
• Allow Append statements
  Allows you to generate statements that use the File Upload type append
• Allow Update statements
  Allows you to generate statements that use the File Upload type update

Tables

You can select the table types that you want to include.

• Show All table types
  Shows all defined table types
• Table
  Show tables
• View
  Shows views
• System table
  Shows system tables
• Alias
  Shows aliases
• Synonym
  Shows synonyms
• Global temporary
  Shows global temporary tables
• Local temporary
  Shows local temporary tables

Drivers

The Drivers tab allows you to register JDBC drivers not provided as part of this program package. You can also remove previously-registered drivers.

User Options

The User Options tab is used to restrict a user's ability to modify certain options. An administrator can grant a user the ability to modify all options, or the ability to modify only selected option groups.

• Allow user to configure Database On-Demand options
  Allows modification of ALL options.
• Allow user to configure general options
  Allows modification of the General options.
• Allow user to configure tables options
  Allows modification of the Tables options.
• Allow user to register JDBC drivers
  Allows modification of the registered JDBC drivers.
• Allow user to configure default logon properties
  Allows modification of the default logon properties.
• Allow user to configure BiDi options
  Allows modification of the BiDi options.

Related topics

• Database On-Demand Overview