Re: Import bug

From: Andy Hassall <andy_at_andyh.org>
Date: Sat, 29 Jun 2002 00:16:44 +0100
Message-ID: <kgrphugid8lrvsmbs5fj9jsiqfhomnnjl4@4ax.com>

On Sat, 29 Jun 2002 08:52:38 +1000, "Howard J. Rogers" <dba_at_hjrdba.com> wrote:

>But that's a special case, I'm afraid. The DBA role in 9i R2 has the 'grant
>any object' privilege, which is new. So yes, it works in 9i R2, but not in
>any earlier version.
>
>Not even SYS could grant rights to Scott's tables in prior releases.

Ah! That would explain it. Only tried it on 9iR2; should have given it a go on the 8i instance too. Thanks.

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

Received on Fri Jun 28 2002 - 18:16:44 CDT