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

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.