i believe the reason that you can do an imp fromuser/touser is that either
they have dba type privileges, or that they have imp_full_database
privileges. I do not wish to give the users those privileges as they can be
dangerous. If i am incorrect please let me know as i am still new at this.
thank you.
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-----
Sent: Wednesday, May 16, 2001 6:23 PM
To: Multiple recipients of list ORACLE-L
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:[EMAIL PROTECTED]>
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: [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).
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
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).
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).
