RE: imp/exp privilege ?

I am curious, why couldn't you just do an import and issue the FROMUSER and the TOUSER?
I do it all of the time and it works fine for me. Kev

-----Original Message-----
Nechama
Sent: Wednesday, May 16, 2001 5:56 PM
To: Multiple recipients of list ORACLE-L

Thank you.

I did not realize that BECOME USER only allowed you to import someone else's exported schema. This privilege is perfect for what I need. Elegant and simple.

Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
nglasrot @seisint.com <mailto:nglasrot_at_seisint.com> Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695

-----Original Message-----
Sent: Tuesday, May 15, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L

"Glasrot, Nechama" wrote:

> How can I create the environment that allows UserA to export his schema,
and
> UserB can import fromuser=UserA touser=UserB.

I think the BECOME USER privilege might possibly be what you're looking for.

    GRANT BECOME USER TO userb;

Does that do what you want? It is one of the many privileges that is included
in the IMP_FULL_DATABASE role.

Short of that, I guess you could have a batch job that runs the import into another schema and allow the second user to read the objects in that schema...that's probably not a new thought to you, though.

Bill

--

______________________________________________
http://www.datacraft.com/    http://plnet.org/


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Pribyl
  INET: bill_at_datacraft.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


This transmission may contain information that is privileged, confidential
and exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED.
If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or
hard copy format.
Thank you


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Glasrot, Nechama
  INET: NGlasrot_at_seisint.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).