Re: Pls Help - full name of users

USER_USERS is a dictionary view based on several tables, which allows the users to see their individual DBA_USERS records. You'll need to create a separate table, and query that in place of USER_USERS (using the user pseudocolumn) such as

select FullName from mytable
where myuserid = user;

See http://www.lonyx.com for tips and techiniques for Oracle databases.

Larry <lnitzu_at_my-deja.com> wrote in message news:8id8fv$jvv$1_at_nnrp1.deja.com...
> 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