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