Re: user not in dba_users but has record in dba_role

From: <argosy22_at_my-deja.com>
Date: 2000/05/24
Message-ID: <8ghi9f$7c$1@nnrp1.deja.com>#1/1

If you can afford to, perhaps try

drop user user_name
cascade

This will find all the columns in all views/tables where the column name is user. That might help you.

Select     substr(owner, 1, 15) owner,
     substr(table_name, 1, 30) table_name,
     column_name

From all_tab_columns
Where upper(column_name) like UPPER(LTRIM(RTRIM( '%USER%' ))) order by 1, 2, 3

Good luck

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 ???
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
>

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

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