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.

See Also

OMBUNREGISTER USER

OMBALTER USER

OMBRETRIEVE USER