Re: Creator of a role gets what rights?

Brian Peasland wrote:

> But a role is neither a system or object privilege. It is a role.
> Whether you can grant that role is determined by whether or not you are
> the creator or have been given the GRANT ANY ROLE system privilege. And
> you can't grant a role with the ADMIN or GRANT option, so to speak.
>
> HTH,
> Brian
>

Et tu Brutus?

From the examples in the "Oracle9i SQL Reference, Release 2 (9.2)", section GRANT, examples at

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/statements_912a.htm#2081423

>>>>>>>

Granting a Role with the Admin Option: Example To grant the dw_manager role with the ADMIN OPTION to the sample user sh, issue the following statement:

GRANT dw_manager

   TO sh
   WITH ADMIN OPTION; User sh can now perform the following operations with the dw_manager role:

Enable the role and exercise any privileges in the role's privilege domain, including the CREATE MATERIALIZED VIEW system privilege
Grant and revoke the role to and from other users Drop the role
<<<<<<<<

note the materiaized view part is because role dw_manager has those capabilities in an earlier part of the example. Received on Tue Jun 24 2003 - 10:59:09 CDT