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
 

OMBGRANT SYS_PRIV

Purpose

To grant a list of system privileges to a list of users or roles.

Prerequisites

Must be connected to a workspace on OWB repository.

Syntax

parseGrantSysPrivCommand =  OMBGRANT ( SYS_PRIV | SYSTEM_PRIVILEGE ) 
          "sysPrivNameList" TO ( USER "userOrRoleNameList" | ROLE 
          "userOrRoleNameList" ) 
     sysPrivNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     userOrRoleNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }

Parameters

parseGrantSysPrivCommand

This clause grants a list of system privileges to a list of users or roles.

sysPrivNameList

List of system privileges. Valid system privileges are:ACCESS_PUBLICVIEW_BROWSER, CONTROL_CENTER_DEPLOYMENT, CONTROL_CENTER_EXECUTION,CONTROL_CENTER_VIEW,CREATE_EXTENSIONMODEL,CREATE_PROJECT, CREATE_SNAPSHOT

userOrRoleNameList

List of valid OWB user names or OWB role names.