OMBREVOKE OBJ_PRIV

Purpose

To revoke a list of object privileges on the specified objects from a list of users or roles.

Prerequisites

Must be connected to a workspace on OWB repository.

Syntax

parseRevokeObjPrivCommand =  OMBREVOKE ( OBJ_PRIV | OBJECT_PRIVILEGE ) 
          "objPrivNameList" ON "UNQUOTED_STRING" "QUOTED_STRING" [ CASCADE ] 
          FROM ( USER "userOrRoleNameList" | ROLE "userOrRoleNameList" ) 
     objPrivNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     userOrRoleNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }

Parameters

parseRevokeObjPrivCommand

This clause revokes a list of object privileges on the specified objects from 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.

objPrivNameList

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

userOrRoleNameList

List of valid OWB user names or OWB role names.