SQL SECURITY
------------
Key: CORE-5568
URL: http://tracker.firebirdsql.org/browse/CORE-5568
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Roman Simakov
Makes it possible to execute some objects with permissions of either definer or
invoker.
By default INVOKER is used to keep backward compatibility.
If INVOKER is specified a current set of privileges of the current user will be
used.
If DEFINER - a set of privileges of object owner will be used to check an
access to database objects used by this object.
Trigger inherits SQL SECURITY option from TABLE but can overwrite it by
explicit specifying. If SQL SECURITY option
will be changed for table, existing triggers without explicitly specified
option will not use new value immediately
it will take effect next time trigger will be loaded into metadata cache.
For procedures and functions defined in package explicit SQL SECURITY clause is
prohibit.
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
