OMBGRANT DEFAULT_OBJ_PRIV

Purpose

To change the default object privilege setting property of a user, basically it will grant a list of default object privileges to a list of users or roles. These object privileges will really 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

parseGrantDefObjPrivCommand =  OMBGRANT DEFAULT ( OBJ_PRIV | 
          OBJECT_PRIVILEGE ) "objPrivNameList" TO ( USER "userOrRoleNameList" | 
          ROLE "userOrRoleNameList" ) [ FOR USER "QUOTED_STRING" ] 
     objPrivNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     userOrRoleNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }

Parameters

parseGrantDefObjPrivCommand

This clause change the default object privilege setting property of a user through granting a list of default object privileges to 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