New clause "autogrant" for create/alter procedure/trigger statement
-------------------------------------------------------------------
Key: CORE-3725
URL: http://tracker.firebirdsql.org/browse/CORE-3725
Project: Firebird Core
Issue Type: Improvement
Components: Scripts
Environment: DDL scripts
Reporter: Boulitchev Alexey
Priority: Minor
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 :)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
