OMBLIST ALL OBJ_PRIVS

Purpose

To list all the object privileges granted to a specified user on a specified object, some of which my be inherited from granted roles. Note: A role will not be granted to another role, so OMBLIST OBJ_PRIVS and OMBLIST ALL OBJ_PRIVS actually will list the same result for roles.

Prerequisites

Must be connected to a workspace on OWB repository.

Syntax

parseListAllObjPrivs =  OMBLIST ALL ( OBJ_PRIVS | OBJECT_PRIVILEGES ) ON 
          "UNQUOTED_STRING" "QUOTED_STRING" ( OF ( USER | ROLE ) "QUOTED_STRING"
           )

Parameters

parseListAllObjPrivs

This clause lists all the object privileges granted to a specified user on a specified object, some of which my be inherited from granted roles. Note: A role will not be granted to another role, so OMBLIST OBJ_PRIVS and OMBLIST ALL OBJ_PRIVS actually will list the same result for roles.