Re: Pls Help - full name of users

Hi guys,

External name is not available as an option in this case. For more info read the following:

"The 'external_name' string is the X.509 name at the Oracle Security Service that identifies this user."

Hope this helps.

Joel

Jonathan Gennick wrote:

> 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