OMBLIST DEFAULT_OBJ_PRIVS

Purpose

To list all the default object privileges granted to a specified role or user from the owner, some of which may be inherited from the granted roles. These object privileges will really be granted to the specified user or role on the new object whenever the owner creates it.

Prerequisites

The default object privileges can be listed from any context.

Syntax

parseListAllDefObjPrivs =  OMBLIST ALL DEFAULT ( OBJ_PRIVS | 
          OBJECT_PRIVILEGES ) ( OF ( USER | ROLE ) "QUOTED_STRING" ) [ FOR USER 
          "QUOTED_STRING" ]

Parameters

parseListAllDefObjPrivs

This clause will show the default object privilege setting property of a user, basically will list all the default object privileges granted to a specified role or user from the owner. The list result includes the default object privileges granted directly to a user and the default object privileges inherited by the user. Note: A role will not be granted to another role, so OMBLIST DEFAULT OBJ_PRIVS and OMBLIST ALL DEFAULT OBJ_PRIVS actually will list the same result for roles. The default object privileges will be really ganted to the specified user or role on the newly created object by the owner.