GetPrivs Function

This function returns a comma-separated list of all privileges that the current user has for the specified workspace.

Syntax

DBMS_WM.GetPrivs (
   workspace  VARCHAR2) 
RETURN VARCHAR2;

Parameters

Table 70-15 GetPrivs Function Parameters  

Parameter	Description
workspace	Name of the workspace for which to return the list of privileges. The name is case sensitive.

Usage Notes

For information about Workspace Manager privileges, see Oracle9i Application Developer's Guide - Workspace Manager.

Examples

The following example displays the privileges that the current user has for the B_focus_2 workspace.

SELECT DBMS_WM.GetPrivs ('B_focus_2') FROM DUAL;

DBMS_WM.GETPRIVS('B_FOCUS_2')                                                        
--------------------------------------------------------------------------------
ACCESS,MERGE,CREATE,REMOVE,ROLLBACK