Re: [Firebird-devel] DROP SQL SECURITY for trigger
Makes sense. Thanks. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Mon, Feb 14, 2022, at 15:26, Roman Simakov wrote: > It's possible to alter a trigger partly, alter an option of a trigger. > SQL SECURITY is one of such options. For procedures you must specify > "complete definition" every time. > > пн, 14 февр. 2022 г. в 12:35, Jiří Činčura : >> >> Hi *, >> >> I'm wondering why is there explicit "DROP SQL SECURITY" for triggers, while >> i.e. procedures use regular "alter" statement? >> >> -- >> Mgr. Jiří Činčura >> https://www.tabsoverspaces.com/ >> >> >> Firebird-Devel mailing list, web interface at >> https://lists.sourceforge.net/lists/listinfo/firebird-devel > > > > -- > Роман Симаков > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] DROP SQL SECURITY for trigger
It's possible to alter a trigger partly, alter an option of a trigger. SQL SECURITY is one of such options. For procedures you must specify "complete definition" every time. пн, 14 февр. 2022 г. в 12:35, Jiří Činčura : > > Hi *, > > I'm wondering why is there explicit "DROP SQL SECURITY" for triggers, while > i.e. procedures use regular "alter" statement? > > -- > Mgr. Jiří Činčura > https://www.tabsoverspaces.com/ > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Роман Симаков Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] DROP SQL SECURITY for trigger
Hi *, I'm wondering why is there explicit "DROP SQL SECURITY" for triggers, while i.e. procedures use regular "alter" statement? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel