Subject RE: [IBDI] Re: Internet
Author Claudio Valderrama C.
> -----Original Message-----
> From: alex_vnru@... [mailto:alex_vnru@...]
> Sent: Martes 5 de Junio de 2001 12:42
> And you can
> prevent access of particular user to particular database too making
> grant select on rdb$relations to this_user
> revoke select on rdb$relations from this_user
> within this database.

This bizarre command works because the engine has two layers of security,
the flexible (and original) security classes on the base and the weak one on
top, called user privileges (to support SQL). Those two layers produce
surprising results sometimes when they interact. Just be sure not to define
two tables or procedures that have the first 27 letters being the same or
you will have more surprises.