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

Reply via email to