Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 25 of 52
This procedure grants system-level privileges (not restricted to a particular workspace) to users and roles. The grant_option
parameter enables the grantee to then grant the specified privileges to other users and roles.
DBMS_WM.GrantSystemPriv( priv_types IN VARCHAR2, grantee IN VARCHAR2 [, grant_option IN VARCHAR2 DEFAULT 'NO'] [, auto_commit IN BOOLEAN DEFAULT TRUE]);
Contrast this procedure with GrantWorkspacePriv Procedure, which grants workspace-level Workspace Manager privileges with keywords that do not contain ANY
and which has a workspace
parameter.
If a user gets a privilege from more than one source and if any of those sources has the grant option for that privilege, the user has the grant option for the privilege. For example, assume that user SCOTT
has been granted the ACCESS_ANY_WORKSPACE
privilege with grant_option
as NO
, but that the PUBLIC
user group has been granted the ACCESS_ANY_WORKSPACE
privilege with grant_option
as YES
. Because user SCOTT
is a member of PUBLIC
, user SCOTT
has the ACCESS_ANY_WORKSPACE
privilege with the grant option.
The WM_ADMIN_ROLE
role has all Workspace Manager privileges with the grant option. The WM_ADMIN_ROLE
role is automatically given to the DBA
role.
The ACCESS_WORKSPACE
or ACCESS_ANY_WORKSPACE
privilege is needed for all other Workspace Manager privileges.
To revoke system-level privileges, use the RevokeSystemPriv 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 enables user Smith
to access any workspace in the database, but does not allow Smith
to grant the ACCESS_ANY_WORKSPACE
privilege to other users.
EXECUTE DBMS_WM.GrantSystemPriv ('ACCESS_ANY_WORKSPACE', 'Smith', 'NO');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|