Re: Import bug

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.

That's still not an issue with import, however, or the original poster's problem with quotas. It happens that the tool does something special with object privileges, and not with quotas. So? You live with it... it's not as if there aren't workarounds, nor that this hasn't been expected behaviour for years and years.

Regards
HJR "Andy Hassall" <andy_at_andyh.org> wrote in message news:e4pphu83smnbrkl1hcnabq5ev8rla65kgs_at_4ax.com...
> On Fri, 28 Jun 2002 17:01:49 -0400, "Chuck" <chuckh_at_softhome.net> wrote:
>
> >Oh really? Not a specal case? Then how does the DBA doing the full import
> >manage to grant permissions on objects he doesn't own if it's not a
special
> >case? Try doing that under normal cicumstances. It doesn't work does it?
>
> If by DBA user you mean a user with the DBA role...
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
>
> SQL> create user dbauser identified by dbauser;
>
> User created.
>
> SQL> grant dba to dbauser;
>
> Grant succeeded.
>
> SQL> connect dbauser/dbauser_at_ajh9i
> Connected.
> SQL> select table_name from dba_tables where owner = 'TEST';
>
> TABLE_NAME
> ------------------------------
> PLAN_TABLE
> TEST
>
> SQL> create user test2 identified by test2;
>
> User created.
>
> SQL> grant select on test.test to test2;
>
> Grant succeeded.
>
> --
> 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 - 17:52:38 CDT