Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

OMBCREATE ROLE

Purpose

To create a Warehouse Builder role.

Prerequisites

Must be connected to a workspace on OWB repository.

Syntax

parseCreateRoleCommand =  OMBCREATE ( ROLE "QUOTED_STRING" [ SET 
          "setPropertiesClause" ] ) 
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

parseCreateRoleCommand

This clause creates a Warehouse Builder role.

setPropertiesClause

Used to set properties of a Warehouse Builder role. Valid properties are shown below.

getPropertiesClause

Basic properties for ROLE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the role

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the role

propertyNameList

A list of valid properties are shown in section of Basic properties for Role.

propertyValueList

A list of valid property value shown in section of Basic properties for Role.

propertyValue

The valid property value shown in section of Basic properties for Role.