absolutely ... i just had the same case ...
1/ user one can always export his/her own schema ...
2/ GRANT BECOME USER to user2
3/ user2 can now import user1's export
warning ... if user1 has dba privileges then user2 cannot import
hth
Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
nglasrot @seisint.com <mailto:[EMAIL PROTECTED]>
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695
-----Original Message-----
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 15, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L
We need to allow a user to export/import a different user's objects.
We want to limit access to the designated schema, so we're trying to
avoid granting EXPORT/IMPORT_FULL_DATABASE. We don't want passwords
embedded within scripts either, for obvious reasons.
Is there any way to do this?
--
My employers like me, but not enough to let me speak for them.
Greg Norris
Sprint LTD Database Administration
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
