../E14406-01.epub /> ../E14406-01.mobi />

OMBREGISTER USER

Purpose

To register a database user as a Warehouse Builder user.When you issue this command, the operation is implicitly committed.

Prerequisites

Commit or Rollback is needed if there is any change.

Syntax

parseRegisterUserCommand =  ( OMBREGISTER USER "QUOTED_STRING" [ SET 
          PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" 
          ")" ] [ WITH CREATE DBUSER OPTION IDENTIFIED BY "QUOTED_STRING" [ 
          DEFAULT_TABLESPACE2 "QUOTED_STRING" ] [ TEMPORARY_TABLESPACE 
          "QUOTED_STRING" ] THROUGH SYSDBA CONNECTION "UNQUOTED_STRING" ] )
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

parseRegisterUserCommand

This command registers a Warehouse Builder user.

propertyNameList

A list of valid properties are shown below.

getPropertiesClause

Basic properties for USER:

getPropertiesClause

Name: PROMPT_FOR_COMMIT
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: PROMPT_FOR_JOB_NAME
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: PROMPT_FOR_EXECUTION_PARAMS
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: SHOW_MONITOR
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: SHOW_DEPLOYMENT_COMPLETION
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: SHOW_DEPLOYMENT_DEPENDENCIES
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: SHOW_MONITOR_RESULTS
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: SHOW_MONITOR_LOGFILE
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: PERSONALITY
Type: STRING
Valid Values: Any valid character string in supported character set.
Default:  Default

Name: SHOW_GUIDED_ASSISTANCE
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: HIDE_WIZARD_WELCOME_PAGES
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: SHOW_DELETE_CONFIRMATION
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: RECYCLE_DELETED_OBJECTS
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: EMPTY_RECYCLE_BIN
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: CLEAR_CLIPBOARD
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: SHOW_GENERATION_PROJECT
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: SHOW_GENERATION_MODULE
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: SHOW_GENERATION_LOCATION
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: SHOW_GENERATION_ACTION
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: SHOW_GENERATION_TYPE
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: LOG_FILE_PATH
Type: STRING(1000)
Valid Values: Any valid character string in supported character set.
Default: Empty string

Name: LOG_FILE_NAME
Type: STRING(1000)
Valid Values: Any valid character string in supported character set.
Default:  log

Name: LOG_FILE_MAX_SIZE
Type: STRING
Valid Values: 1-10000000
Default:  100

Name: LOG_ERROR_MESSAGES
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: LOG_WARNING_MESSAGES
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: LOG_INFORMATION_MESSAGES
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: NAMING_MODE
Type: STRING
Valid Values: PHYSICAL_NAMING_MODE, BUSINESS_NAMING_MODE
Default:  PHYSICAL_NAMING_MODE

Name: PROPAGATE_NAME_CHANGES
Type: BOOLEAN
Valid Values: true, false
Default:  false

Name: DESIGNREPOS_PWD_PERSIST
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: RUNTIMEREPOS_PWD_SHARE
Type: BOOLEAN
Valid Values: true, false
Default:  true

Name: DEFAULT_SEC_POLICY
Type: STRING
Valid Values: MINIMUM_SECURITY, MAXIMUM_SECURITY
Default:  MINIMUM_SECURITY

propertyValueList

A list of valid property values. Refer to section of Basic properties for USER.

propertyValue

The valid property value. Refer to section of Basic properties for USER.