> I'm just working round this myself (python not java).
>
> I don't know why this happens - no doubt you'd get an exception when the
> user tries to action something he/she doesn't have privileges for.
>
> I don't know if this is the best solution but you could create a view
> something like:
>
> create view administratorrole_p as select rdb$relation_name from
> rdb$user_privileges where rdb$user = (select current_user from

rdb$database)

> and rdb$relation_name = ADMINISTRATORROLE"

Just a short note - this should work too:

rdb$user_privileges where rdb$user = CURRENT_USER



With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."