Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 36 of 52
This procedure revokes (removes) system-level privileges from users and roles.
DBMS_WM.RevokeSystemPriv( priv_types IN VARCHAR2, grantee IN VARCHAR2 [, auto_commit IN BOOLEAN DEFAULT TRUE]);
Contrast this procedure with RevokeWorkspacePriv Procedure, which revokes workspace-level Workspace Manager privileges with keywords in the form xxx_WORKSPACE (ACCESS_WORKSPACE
, MERGE_WORKSPACE
, and so on).
To grant system-level privileges, use the GrantSystemPriv 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 workspaces and merging changes in workspaces.
EXECUTE DBMS_WM.RevokeSystemPriv (`ACCESS_ANY_WORKSPACE, MERGE_ANY_WORKSPACE', `Smith');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|