Re: Alter an Oracle user name
Date: Tue, 16 Oct 2001 12:33:09 -0400
Message-ID: <9qhng3$obqcf$1_at_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 - 18:33:09 CEST