You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I need automatic privileges assignment for procedure or triggers for used objects.
Actually, in RDB$DEPENDENCIES i can find only fact of dependence, without type (select, insert etc). Because we deploy database without procedure sources, we have troubles for grants. Server's engine can resolve dependence on stage preparing statement from BLR.
DDL operator, like this:
create or alter procedure MY_PROCEDURE with grants
as
begin
update MY_TABLE where ID = 0;
execute ANOTHER_PROCEDURE;
end
grant select, update on MY_TABLE to procedure MY_PROCEDURE;
grant execute on ANOTHER_PROCEDURE to procedure MY_PROCEDURE;
Excuse my google inglish :)
The text was updated successfully, but these errors were encountered:
Submitted by: Boulitchev Alexey (pastor)
Votes: 1
I need automatic privileges assignment for procedure or triggers for used objects.
Actually, in RDB$DEPENDENCIES i can find only fact of dependence, without type (select, insert etc). Because we deploy database without procedure sources, we have troubles for grants. Server's engine can resolve dependence on stage preparing statement from BLR.
DDL operator, like this:
create or alter procedure MY_PROCEDURE with grants
as
begin
update MY_TABLE where ID = 0;
execute ANOTHER_PROCEDURE;
end
grant select, update on MY_TABLE to procedure MY_PROCEDURE;
grant execute on ANOTHER_PROCEDURE to procedure MY_PROCEDURE;
Excuse my google inglish :)
The text was updated successfully, but these errors were encountered: