Re: Problem with granting object permissions to a role

On 7 Feb 2003 08:55:17 -0800, Pete Sharman <peter.sharman_at_oracle.com> wrote:

>I didn't see any version numbers in your posting, so there might be two answers
>to this. Prior to 9.2 you needed to log on as the owner of the object or
>someone who had been granted access WITH GRANT OPTION (that last bit allows them
>to pass it on). In 9.2, this is no longer the case (sounds of the Hallelujah
>Chorus resound!). ANyone with DBA privileges can grant access in 9.2 (can't
>remember off the top of my head if this comes with the DBA role or SYSDBA).

 It's the GRANT ANY OBJECT PRIVILEGE privilege (granted to DBA).

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)