CREATE DOMAIN

Defines a security domain to authenticate users for an existing tenant or a super-tenant. The domain name must be unique within the set of domain names that are defined for a database. A tenant can be associated with multiple domains.

Syntax

CREATE DOMAIN domain_name
  FOR { TENANT tenant_name| SUPER_TENANT super-tenant_name}
      [ PRO_DESCRIPTION value];

Parameters

domain_name

Specifies the name of the security domain. You must specify the domain name even if it is the same as the tenant name.

TENANT tenant_name

Specifies the name of an existing tenant. For a DEFAULT tenant, you must specify default as the tenant name.

SUPER_TENANT super-tenant_name

Specifies the name of the tenant defined as a super-tenant in the database.

PRO_DESCRIPTION value

Allows you to enter an ABL description. The value attribute is an arbitrary character string.

Example

The following example illustrates how to create a tenant and a domain for the tenant.

To define a tenant called Mega_Media_Networks:

CREATE TENANT Mega_Media_Networks TABLE AREA "MMM Data area"
INDEX AREA "MM index area"
LOB AREA "MMM pix area" ;

To define a domain for the tenant Mega_Media_Networks:

CREATE DOMAIN dom_MMNet FOR TENANT Mega_Media_Networks;

To specify users who can securely connect to the domain dom_MMNet, you must create users and associate them with the domain dom_MMNet.

In this section:

Authorization

Related Statement