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

OMBLIST ALL SYS_PRIVS

Purpose

To list all the system privileges granted to a user or a role, some of the privileges may be inherited from the granted roles. Note: A role will not be granted to another role, so OMBLIST SYS_PRIVS and OMBLIST ALL SYS_PRIVS actually will list the same result for roles.

Prerequisites

All System privileges granted to a user or a role can be listed from any context.

Syntax

parseListAllSysPrivs =  OMBLIST ALL ( SYS_PRIVS | SYSTEM_PRIVILEGES ) ( OF 
          USER "QUOTED_STRING" )

Parameters

parseListAllSysPrivs

This clause lists the overall system privileges granted to a user or a role. Some of the privileges may inherited from granted roles. Note: A role will not be granted to another role, so OMBLIST SYS_PRIVS and OMBLIST ALL SYS_PRIVS actually will list the same result for roles.