Subject Re: [ib-support] Access RDB$User_Privileges table directly?
Author Claudio Valderrama C.
"Damian Dowling" <it-manager@...> wrote in message
> Hi
> Is it safe to access the RDB$User_Privileges table directly for reading
> 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

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.

Claudio Valderrama C. - -
Independent developer
Owner of the InterbaseĀ® WebRing