Re: Rename a user ?

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.

--
David T. Bath (from home) david.bath_at_nre.vic.gov.au Phone: +613 9500 0894 Mobile: 015 824 171 (not always on) Office: Global Consulting Ph:+613 9347 7511 Fax:+613 9347 0182 #include <std_disclaim.h> Received on Fri Jun 26 1998 - 20:22:02 CDT