RE: imp/exp privilege ?
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).
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:[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).
RE: imp/exp privilege ?
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
Re: imp/exp privilege ?
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).
imp/exp privilege ?
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:[EMAIL PROTECTED] 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).