Subject | Re: [Firebird-Architect] Execute procedure using Role ? |
---|---|
Author | Vlad Khorsun |
Post date | 2009-05-24T10:02:21Z |
>>> This is not really an RFC, more like an RFI: request for ideas.No, sorry, as it is not exists yet (as packages not exists yet in FB)
>
>> Idea : are the package private variable suit your needs ?
>
> Can you point me to some documentation?
> I've read through some of the discussion (on here) aboutPackages is like Pascal units. With interface\implementation parts.
> packages back in July 2008, but could not find any details
> of private variables in there (and I am not familiar with
> Oracle).
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