|Subject||Re: [ib-support] Why can I login into a db with a role I have never been granted?|
> I'm just working round this myself (python not java).rdb$database)
> 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
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
"This is an object-oriented system.
If we change anything, the users object."