Re: user not in dba_users but has record in dba_role

From: <buckeye714_at_my-deja.com>
Date: 2000/05/23
Message-ID: <8geptl$1b2$1@nnrp1.deja.com>#1/1

In article <14e5a181.2a2100c9_at_usw-ex0109-070.remarq.com>, Chi <chi.hsiang.chihNOchSPAM_at_nl.abnamro.com.invalid> wrote:
> Server Oracle 8.0.5. running on NT 4.
>
> When I try to create the user, it will give ORA-01920 (user
> exists).
>
> Is this a bug ??
>
> It seems to me when a user exists in dba_role_privs the same
> user should have a record in dba_users ???
>

What username are you trying create? Is it possible that you are trying to use a name that corresponds to an existing role? This would also cause that error.

HTH,
Patrick

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 23 2000 - 00:00:00 CDT

Re: user not in dba_users but has record in dba_role_privs ???