Re: Renaming oracle users.

finkej_at_ts.its.rpi.edu (Jon E. Finke) writes:

>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).

why?!

>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.

well you are going to pay for this because you cann't get rid of the old id's and if you used to be ops$root with crd priv and you changed but you'r script failed and some one else picked it then ta-da they got ya.

>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.
>

bill_at_chaos.cs.umn.edu

--
bill_at_chaos.cs.umn.edu