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

Part Number 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 DEFAULT_OBJ_PRIV

Purpose

To change the default object privilege setting property of a user, basically it will revoke a list of default object privileges from a list of users or roles. These object privileges will not be granted to the specified user or role on the new objects whenever the owner creates them.

Prerequisites

Must be connected to a workspace on OWB repository.

Syntax

parseRevokeDefObjPrivCommand =  OMBREVOKE DEFAULT ( OBJ_PRIV | 
          OBJECT_PRIVILEGE ) "objPrivNameList" FROM ( USER "userOrRoleNameList" 
          | ROLE "userOrRoleNameList" ) [ FOR USER "QUOTED_STRING" ] 
     objPrivNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     userOrRoleNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }

Parameters

parseRevokeDefObjPrivCommand

This clause changes the default object privilege setting property of a user through revoking a list of default object privileges from a list of users or roles.

objPrivNameList

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

userOrRoleNameList

List of valid OWB user names or OWB role names.

See Also