OMBGRANT OBJ_PRIV

Purpose

To grant a list of object privileges on the specified objects to a list of users or roles.

Prerequisites

Must be connected to a workspace on OWB repository.

Syntax

parseGrantObjPrivCommand =  OMBGRANT ( OBJ_PRIV | OBJECT_PRIVILEGE ) 
          "objPrivNameList" ON "UNQUOTED_STRING" "QUOTED_STRING" [ CASCADE ] TO 
          ( USER "userOrRoleNameList" | ROLE "userOrRoleNameList" ) 
     objPrivNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     userOrRoleNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }

Parameters

parseGrantObjPrivCommand

This clause grants a list of object privileges on the specified objects to a list of users or roles.

UNQUOTED_STRING

The type of the objects to be listed.Valid object types are: PROJECT, ORACLE_MODULE, FLAT_FILE_MODULE, PROCESS_FLOW_MODULE, SAP_MODULE, BUSINESS_DEFINITION_MODULE, OBIEE_BUSINESS_DEFINITION_MODULE, BUSINESS_PRESENTATION_MODULE, TRANSFORMATION_MODULE, PACKAGE, ADVANCED_QUEUE, BUSINESS_AREA, COLLECTION, CONNECTOR, CUBE, DIMENSION, EXTERNAL_TABLE, FLAT_FILE, FUNCTION, REGISTERED_FUNCTION, MAPPING, MATERIALIZED_VIEW, OBJECT_TYPE, PROCEDURE, ITEM_FOLDER, DRILL_PATH, DRILLS_TO_DETAIL, ALTERNATIVE_SORT_ORDER, LISTS_OF_VALUE, PRESENTATION_TEMPLATE, SEQUENCE, TABLE, PROCESS_FLOW, PROCESS_FLOW_PACKAGE, LOCATION, CONTROL_CENTER, CONFIGURATION, DEPLOYMENT, VIEW.

QUOTED_STRING

an object name or a regular expression refers to a list of objects whose name matches the regular expression.

CASCADE

grant the specified object privileges on a folder object and all its child objects cascade down. Note: if CASCADE is used, the string used to specify the object can only refer to one object and not be a regular experssion .

objPrivNameList

Object privileges. Valid object privileges are: READ, COMPILE, EDIT, FULL_CONTROL.

userOrRoleNameList

List of valid OWB user names or OWB role names.