Configuration objects are objects that are stored in the ElevateDB configuration file, which is represented by the special system-created Configuration database. Creating, altering, or dropping configuration objects can be accomplished by using the TEDBSession Execute method to execute the desired DDL (Data Definition Language) statement against the Configuration database. This method is always set to execute any passed SQL statement from the context of the Configuration database, which makes it ideal for use in creating, altering, or dropping configuration objects such as databases, users, roles, and jobs with a minimal amount of work.

The following example shows how to create a database called "Test" using the CREATE DATABASE DDL statement:

// This example uses a session component that
// has already been created and connected
// called MySession

with MySession do
   Execute('CREATE DATABASE "Test" PATH ''C:\Test'''+
           'DESCRIPTION ''Test Database''');

Configuration Object DDL Statements

---

The following DDL statements can be used to manipulate the various configuration objects available in the Configuration database:

   • CREATE USER
   • ALTER USER
   • DROP USER
   • RENAME USER
   • CREATE ROLE
   • ALTER ROLE
   • DROP ROLE
   • RENAME ROLE
   • GRANT ROLES
   • REVOKE ROLES
   • GRANT PRIVILEGES
   • REVOKE PRIVILEGES
   • CREATE DATABASE
   • ALTER DATABASE
   • DROP DATABASE
   • RENAME DATABASE
   • CREATE JOB
   • ALTER JOB
   • DROP JOB
   • RENAME JOB
   • CREATE MODULE
   • ALTER MODULE
   • DROP MODULE
   • RENAME MODULE
   • CREATE MIGRATOR
   • ALTER MIGRATOR
   • DROP MIGRATOR
   • RENAME MIGRATOR
   • CREATE TEXT FILTER
   • ALTER TEXT FILTER
   • DROP TEXT FILTER
   • RENAME TEXT FILTER
   • CREATE WORD GENERATOR
   • ALTER WORD GENERATOR
   • DROP WORD GENERATOR
   • RENAME WORD GENERATOR
   • DISCONNECT SERVER SESSION
   • REMOVE SERVER SESSION

Please see the User Security topic for more information on the required privileges to execute the above DDL statements.