Subject Re: [Firebird-Architect] Execute procedure using Role ?
Author Vlad Khorsun
>>> This is not really an RFC, more like an RFI: request for ideas.
>
>> Idea : are the package private variable suit your needs ?
>
> Can you point me to some documentation?

No, sorry, as it is not exists yet (as packages not exists yet in FB)

> I've read through some of the discussion (on here) about
> packages back in July 2008, but could not find any details
> of private variables in there (and I am not familiar with
> Oracle).

Packages is like Pascal units. With interface\implementation parts.
You could declare any number of public procedures\variables in interface
part and any number of private procedures\variables in implementation
part. All procedure's bodies of course is in implementation part. Private
objects accessible only by another objects of package.

Adriano going to implement package support in v3 (?) and i see no
reason to not implement package variables along with procedures.

For your issue with triggers you could create package with private
variable and public get\set procedures. Grant access on set-procedure
for user callable procedures and grant access on get-procedure for
triggers.

Regards,
Vlad