Re: Pls Help - full name of users
Date: 2000/06/16
Message-ID: <j4jkks0jgpqqgstcr1k9jqmqqhhfsohleq_at_4ax.com>#1/1
[Quoted] There may be a way to set that external name in users_users when you first create a user using the CREATE USER statement, but you should not try to place it into the table (or view) yourself. USER_USERS is a data dictionary view, and those should never be updated directly.
Jonathan
jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are
On Fri, 16 Jun 2000 13:02:01 GMT, Larry <lnitzu_at_my-deja.com> wrote:
>Hi,
>
> I need to keep extra information about users. That is, depending on the
>username and password the user entered the full name
> must be retrieved. I saw that Oracle has a table/view called user_users
>that has a field called external_name. I guess I have to
> enter here the full name, but oracle refuses to accept:
> update user_users set external_name='my name' where user_id=<number>;
>
> It reports: "cannot modify a column which maps to a non key-preserved
>table"
>
> Does anyone know how could I keep full names of the users?
> Many (I mean MANY) thanks in advance!!
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Jun 16 2000 - 00:00:00 CEST