Subject Re: [ib-support] Why can I login into a db with a role I have never been granted?
Author Martijn Tonies
> 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
> 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

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