Renaming oracle users.

In our system, we are planning to allow a procedure for users to change their Unix userids. (BTW, we are running Oracle 6.0.31 on an RS/6000).

For an assortment of reasons, each user has an oracle id (ops${username}) to enable certain administrative functions. For the most part, these folks only have "CONNECT" access, and don't own any objects (tables, views, etc) of any kind.

A change in the Unix userid will require changing the oracle id as well. For those folks without tables, I can delete (well, revoke all access) from the old id, and create a new one. But for users who actually have tables and other objects, I would prefer to rename the existing user, and all of their objects.

I was considering updating the "sys.user$.name" field, but was concerned with just how "safe" this operation would be.

The other trick of course, is that I want to automate this entire process, in fact, the old and new names will be selected from another oracle table and want to avoid any manual keying of data.  

-- 
Jon Finke                              finkej_at_rpi.edu
Senior Network Systems Engineer        USERB239_at_RPITSMTS.BITNET
Information Technology Services        518 276 8185 (voice)
Rensselaer Polytechnic Institute       518 276 2809 (fax)