Re: script to scan show=y log for create user/grant statements
- From: "Robert Stauffer" <rstauffer@xxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Feb 2004 08:55:49 -0500
Adam,
Might the impshow2sql script (or a modification of it) in Metalink note 297=
65.1 be what you're looking for?
Bob Stauffer
D&E Communications
Ephrata, PA USA
717-738-8737
rstauffer@xxxxxxxxxxxxxxxxxxxx
>>> adonahue@xxxxxxxxxxx 02/18/2004 17:29:25 >>>
Folks,
Anyone have a pre-written script to scan an imp show=3Dy log file for=20
those statements necessary to create a user, grant it system privileges=20
and roles, prior to performing a fromuser/touser import of its schema? =20
I figured someone must have done this before. Otherwise, I'll quickly=20
come up with one.
Thanks,
Adam
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx=20
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/=20
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html=20
-----------------------------------------------------------------
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the =
use of the individual or entity to which they are addressed and may contain=
information that is privileged, proprietary and confidential. If you are n=
ot the intended recipient, you may not use, copy or disclose to anyone the =
message or any information contained in the message. If you have received t=
his communication in error, please notify the sender and delete this e-mail=
message. The contents do not represent the opinion of D&E except to the ex=
tent that it relates to their official business.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
