Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 37 of 52
This procedure revokes (removes) workspace-level privileges from users and roles for a specified workspace.
DBMS_WM.RevokeWorkspacePriv( priv_types IN VARCHAR2, workspace IN VARCHAR2, grantee IN VARCHAR2 [, auto_commit IN BOOLEAN DEFAULT TRUE]);
Contrast this procedure with RevokeSystemPriv Procedure, which revokes system-level Workspace Manager privileges with keywords in the form xxx_ANY_WORKSPACE (ACCESS_ANY_WORKSPACE
, MERGE_ANY_WORKSPACE
, and so on).
To grant workspace-level privileges, use the GrantWorkspacePriv Procedure.
An exception is raised if one or more of the following apply:
grantee
is not a valid user or role in the database.
priv_types
.
The following example disallows user Smith
from accessing the NEWWORKSPACE
workspace and merging changes in that workspace.
EXECUTE DBMS_WM.RevokeWorkspacePriv (`ACCESS_WORKSPACE, MERGE_WORKSPACE', `NEWWORKSPACE', `Smith');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|