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

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

OMBALTER ROLE

Purpose

To alter properties of a Warehouse Builder role.

Prerequisites

Must be connected to a workspace on OWB repository.

Syntax

alterRoleCommand =  OMBALTER ( ROLE "QUOTED_STRING" ( "renameClause" [ SET 
          "setPropertiesClause" ] | SET "setPropertiesClause" ) ) 
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterRoleCommand

This clause alters a Warehouse Builder role.

renameClause

renames a role with a different name.

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.