Subject | Re: [firebird-support] Re: limit visibility of store procedure |
---|---|
Author | masotti |
Post date | 2011-04-21T17:24:12Z |
Hi Marco,
On 21/04/2011 15:23, ndirondello marco wrote:
> i'm using fb 2.5 superclassic on windows.
Ok.
>
> maybe what i'm asking is related to the ui application used to manage
> the db (i'm using flame robin that is very simple and with few tools),
> i want only same way to group / hide procedures to better organize them,
> so it will be more easy to manage them.
I don't know if a user/role has filtered out STORED PROCS he/she isn't
granted to execute when listed in client tools like FlameRobin.
A query to system tables can obtain such a list (and you can store it in
a STORED PROC)
IMHO, more or less, that's all.
Ciao.
Mimmo.