Hi,

> Thank you for your reply. I thought I would try and find which field was
> missing and did
>
> select * from rdb$user_privileges p where
> not exists(select * from rdb$relation_fields f where
> f.rdb$field_name=p.rdb$field_name)
> and p.rdb$field_name is not null
>
> but it returned nothing.

How about?

select
*
from
rdb$user_privileges p
where
not exists(
select * from rdb$relation_fields f
where
f.rdb$relation_name = p.rdb$relation_name
f.rdb$field_name = p.rdb$field_name
)
and p.rdb$field_name is not null

> Short of attempting to revoke and reinstate all privileges is there a way of
> finding the rogue record?
>
> Regards
> Paul

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com