RE: Replicating a user across DBs

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
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: Thursday, July 11, 2002 3:46 PM
> To: 'ORACLE-L_at_fatcity.com'
> 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.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> 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
> Rich.Jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> 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: ListGuru_at_fatcity.com (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: Rich.Jesse_at_qtiworld.com

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: ListGuru_at_fatcity.com (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).