|Re: [firebird-support] Re: limit visibility of store procedure
On 21/04/2011 15:23, ndirondello marco wrote:
> i'm using fb 2.5 superclassic on windows.
> 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.