> Thanks for the info. How do I include the First, Middle and Last Names in the select statement?

You can't.

While the user/role membership information is stored per database in
RDB$USER_PRIVILEGES, first/middle/last name of a Firebird user is stored
in security2.fdb, which can be only accessed via the Services API.

So, you could fetch the user list via the Services API and then merge
that information with the role membership information.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/