imp/exp privilege ?

From: Glasrot, Nechama <NGlasrot_at_seisint.com>
Date: Mon, 14 May 2001 08:49:05 -0700
Message-ID: <F001.00302896.20010514070056@fatcity.com>

Good morning all,

Scenario:
UserA/sid=testA
UserB/sid=testB

Problem:
How can I create the environment that allows UserA to export his schema, and UserB can import fromuser=UserA touser=UserB. I do NOT want to grant the roles imp_full_database/exp_full_database to these users, because this allows them too many dba-type privileges including create tablespace, etc.

Any help would be greatly appreciated. TIA

Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
nglasrot <mailto:nglasrot_at_seisint.com>

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). Received on Mon May 14 2001 - 10:49:05 CDT