Re: Cannot DROP a ROLE
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 8 Apr 2003 10:09:55 +0200
Message-ID: <1049789174.522739_at_news.thyssen.com>
Date: Tue, 8 Apr 2003 10:09:55 +0200
Message-ID: <1049789174.522739_at_news.thyssen.com>
"Ralf" wrote...
> Hi TC,
>
> Thanks for your help.
>
> select count(*) from dual;
> has as result: 4
>
> After I truncated the dual-table, the dropping of roles worked fine.
> What can be the reason of getting 4 rows in dual ?
> How many rows are normal for dual ?
>
> Thank you for your hint.
> Ralf
>
Hi Ralf,
number of rows in dual: 1 and *only* 1.
What could've happened to get additional rows into dual? Silly answer: someone (with insert privilege) mad an error (well, 3 errors).
hth,
Guido
Received on Tue Apr 08 2003 - 10:09:55 CEST