Well, almost. Yes, that's what I want to do. It's the manual recreate of the user that bugs me. Perhaps I shouldn't have used the word "replicate"...
The thing that gets me is under 8i, there's no easy way to "GRANT SELECT ON schema_a.table TO schema_b" from a DBA account. I've been using a (undocumented?) procedure called DMBS_SYS_SQL.PARSE_AS_USER to get the job done (thanks to Kevin Percival!), but I was hoping someone had streamlined this trainwreck of a manual procedure. Thanks, but I'm off to a suite Miller Park to drink beer and break the fan boycott. Hey, I'm not that much of a baseball fan anyway, and it's still over a month until Lord Football rises to his Autumnal Throne. ;D Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 3:46 PM > To: '[EMAIL PROTECTED]' > Cc: Jesse, Rich > Subject: RE: Replicating a user across DBs > > > Rich - I have been very busy today, so I'm probably not > reading something > correctly. If you have a user schema in one database, you > must manually > create that userid in the other database, but then you can > use export to > move all the objects to the other database. Import will > create the objects > if they don't exist. Hopefully that responds to your question, but I > apologize if I haven't read it correctly. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > From: Jesse, Rich [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 3:53 PM > To: Multiple recipients of list ORACLE-L > Subject: Replicating a user across DBs > > > Hey all, > > In 8.1.7, is there a way to easily replicate a user from one DB (e.g. > "development") to another (e.g. "production")? I can export > all the objects > in the schema, but export/import won't recreate the schema in > the import DB. > > I've been using OEM to create a script (reverse engineered > from "Create > like..."), but the resulting script requires editing and the > assignment of a > resource plan doesn't always play nice, either. > > There has got to be a better way... > > TIA! > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, > Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > 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: Jesse, Rich 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).
