Thanks Vlad. Now it makes sense.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
21.04.2022 13:38, Jiří Činčura wrote:
Hi,
Can propagate the privileges down into the call stack when using WITH CALLER
PRIVILEGES? For example:
CREATE TABLE T_TEST (ID INTEGER NOT NULL,
CONSTRAINT PK_TEST PRIMARY KEY (ID));
/* Package header: PKG_TEST, Owner: SYSDBA */
CREATE PACKAGE PKG_TEST
My script uses packages (and I grant to package). That's not going to fly on
2.5. :(
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Fri, Apr 22, 2022, at 17:23, Alex Peshkoff via Firebird-devel wrote:
> On 22.04.2022 18:07, Jiří Činčura wrote:
>> Yes. Fails.
>>
>> Do you want me to cre
On 22.04.2022 18:07, Jiří Činčura wrote:
Yes. Fails.
Do you want me to create script for testing?
Can you please check your script on some old version? Like 2.5.
May be I miss something.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-d
Yes. Fails.
Do you want me to create script for testing?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Fri, Apr 22, 2022, at 10:19, Alex Peshkoff via Firebird-devel wrote:
> On 22.04.2022 08:20, Jiří Činčura wrote:
>> Without it, it obviously fail. Because the "limited" user does not
On 22.04.2022 08:20, Jiří Činčura wrote:
Without it, it obviously fail. Because the "limited" user does not have
permissions. That's what I'm trying go around thru the permissions of calling object.
Fails w/o execute statement ? Just using select from procedure instead?
Very strange - this a
Without it, it obviously fail. Because the "limited" user does not have
permissions. That's what I'm trying go around thru the permissions of calling
object.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Thu, Apr 21, 2022, at 14:57, Alex Peshkoff via Firebird-devel wrote:
> On 21.04.
On 21.04.2022 13:38, Jiří Činčura wrote:
I guess the "caller privileges" is propagated only into `pkg_test_limited.test`
when calling, but not further into `t_test`. Can I somewhat make it work/propagate? Or
did I misunderstood the feature?
"with caller privileges" was designed to make priv
Hi,
Can propagate the privileges down into the call stack when using WITH CALLER
PRIVILEGES? For example:
CREATE TABLE T_TEST (ID INTEGER NOT NULL,
CONSTRAINT PK_TEST PRIMARY KEY (ID));
/* Package header: PKG_TEST, Owner: SYSDBA */
CREATE PACKAGE PKG_TEST AS
begin
procedure test returns