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.