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
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
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.
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
