Re: Rename a user ?

You all will want to be REALLY careful trying stuff like that. I've tried stuff similar to that (while doing the RA to AR merge for Oracle Apps Release 9 to 10 upgrades), and wound up trashing two test databases...

Beware!

Jeff Kayser
DBDR Inc.

Joe Kazimierczyk wrote:

> David T. Bath wrote:
> >
> > rprendin_at_my-dejanews.com wrote:
> > >
> > > There is no such command in Oracle.
> > > The work around is create a new user a via export/import
> > > move all the data to the new user... Use the
> > > 'fromuser' and 'touser' parameters in your import parameter file.
> > >
> > > Good Luck,
> > >
> > > Robert Prendin
> > >
> > > In article <6mubqh$mcd$1_at_news1.rmi.net>,
> > > "Gerry West" <gwest_at_skyconnect.com> wrote:
> > > >
> > > > Hi,
> > > >
> > > > Is it possible to rename an Oracle user ?
> > > > If so, how ?
> > > >
> > > > Thanks,
> > > > Gerry West
> > > >
> > > >
> > >
> > > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > > http://www.dejanews.com/ Now offering spam-free web-based newsreading
> >
> > It is possible (at least in versions 4.0 through 7.3) to change
> > the names of things in the appropriate tables.
> >
> > 0. First time? Try on a database you can lose.
> > 1. Get everyone out of the database.
> > 2. Log in as SYS.
> > 3. update the SYS.USR$ table, with the appropriate
> > new user in the SET clause, and old username in the
> > WHERE clause. (I've not given the SQL cause if you
> > cannot figure it out, you shouldn't do it).
> > 4. Commit.
> > 5. Shut down the database and bring it back up again.
> > This is needed to get the new name into the SGA,
> > cache.
> >
> > Similar stunts can be used (with lots of caveats) for object
> > names, column names, etc. But your dependencies could be screwed
> > up.
> >
> > Again: This procedure is inherently perilous. I'd use it to change a
> > username from [a-naughty-word] to something more innocuous, and not
> > much else.
> >

>