Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

New clause "autogrant" for create/alter procedure/trigger statement [CORE3725] #4072

Open
firebird-automations opened this issue Jan 11, 2012 · 0 comments

Comments

@firebird-automations
Copy link
Collaborator

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 :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant