[FB-Tracker] Created: (CORE-5568) SQL SECURITY

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[FB-Tracker] Created: (CORE-5568) SQL SECURITY

JIRA tracker@firebirdsql.org

                 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