RE: imp issue...very confusing!

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 13 Jul 2004 09:13:59 -0700 (PDT)
Message-ID: <20040713161359.23117.qmail@web60702.mail.yahoo.com>

Ron,

Unlimited tablespace as a privilege actually means "you can write to any darned tablespace in the database that you choose to"

you should instead grant quota unlimited to a user on his/her tablespace.

This is one of the "hidden" privileges you get when you grant the role RESOURCE to a user. If you need/want to continue using that role, you should immediately after granting it issue "revoke unlimited tablespace from <username>"

Rachel
--- "Smith, Ron L." <rlsmith_at_kmg.com> wrote:
> I found that when I give a user (touser) unlimited tablespace on
> his/her
> own tablespace, for some reason the user also gets granted unlimited
> tablespace on all tablespaces. When that happens, the fromuser
> touser
> option results in all the objects getting put back into the fromuser
> tablespace. When I revoke unlimited tablespace, the import works
> fine.
>
> Ron Smith
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 13 2004 - 11:11:09 CDT