Create a ticket, please: drop clauses for procedures, functions and packages and inheriting a clause for packages.
вс, 9 мая 2021 г. в 19:35, Mark Rotteveel <m...@lawinegevaar.nl>: > > On 09-05-2021 18:24, Roman Simakov wrote: > > вс, 9 мая 2021 г. в 19:04, Mark Rotteveel <m...@lawinegevaar.nl>: > >> Does that mean that the ALTER DATABASE SET DEFAULT SQL SECURITY <type> > >> influences all objects without an explicit SQL SECURITY property? > > > > I've checked. It influences tables, functions and procedures. Triggers > > inherit it from tables (which already have it inherited from DB). I'm > > afraid packages do not inherit and it's probably a fault as well. > > Thanks. Will you fix it or create a ticket for it? > > >> I had assumed it would specify the default for creating a new object > >> (similar as SET DEFAULT CHARACTER SET). Can you confirm that assumption > >> was wrong? > > > > Yes. The assumption was wrong. SQL SECURITY DEFINER is default in SQL > > STANDARD. > > ALTER DATABASE SET DEFAULT SQL SECURITY DEFINER makes behaviour standard. > > Clear, thanks. I've updated it in the fblangref40 I'm working on. > > Mark > -- > Mark Rotteveel > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Roman Simakov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel