On 09-05-2021 18:38, Roman Simakov wrote:
Create a ticket, please: drop clauses for procedures, functions and packages and inheriting a clause for packages.
Currently, an alter, create or alter or recreate without a SQL SECURITY clause will implicitly drop it for procedures, functions and packages, so I'm not sure those need an explicit drop clause.
I have also tested it, and packages actually do inherit the SQL SECURITY from the database.
Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel