Re: Import bug

From: Andy Hassall <andy_at_andyh.org>
Date: Fri, 28 Jun 2002 23:38:48 +0100
Message-ID: <e4pphu83smnbrkl1hcnabq5ev8rla65kgs@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:38:48 CDT