Subject Re: [ib-support] Access RDB$User_Privileges table directly?
Author Claudio Valderrama C.
"Damian Dowling" <it-manager@...> wrote in message
news:5.1.0.14.2.20010828120346.029e1810@......
> Hi
>
> Is it safe to access the RDB$User_Privileges table directly for reading
and
> updating user access, the reason i ask is that i need a easy way to
> view/set user access, and the GRANT and REVOKE commands are not good
enough.

No, it's unsafe. Most of the validation go into DYN. DYN is only executed if
you use GRANT and REVOKE. Do one mistake directly and you may find problems
later. Information in rdb$user_privileges is translated internally into
entries in rdb$security_classes. There aren't enough validations in the
bowels of the engine. Use a safety net: DDL for grant and revoke.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the InterbaseĀ® WebRing