Re: Alter an Oracle user name

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Tue, 16 Oct 2001 12:33:09 -0400
Message-ID: <9qhng3$obqcf$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"harry" <a_at_abc.com> wrote in message
news:qcnost8iih1tc0d9mig4ooi394s7rtekc2_at_4ax.com...
> Using Oracle 8.1.7
>
> Is it possible to change someone called JOHNSMITH to JACKSMITH?
>
> harry

Not with anything that's supported. You could probably change the underlying system tables, but I wouldn't recommend it.

Your best bet is to export JOHNSMITH's objects and import them into JACKSMITH. Then you'll need to query all grants to JOHNSMITH and grant them to JACKSMITH.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO8xhOWm5A4kkb4ZsEQJDAQCePqxCEeG8zYbLTt4BriBkQTTmpbAAn2IH bvb4L7EGgT8IHpIydpntcD5U
=zcoM
-----END PGP SIGNATURE----- Received on Tue Oct 16 2001 - 11:33:09 CDT