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.