Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

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.