Subject Re: [firebird-support] Utilities which automatically grant privileges to Triggers,Procedures and Views
Author Bambang P
On Wednesday, November 2, 2005, 6:34:43 PM, Si Carter wrote:

>> -----Original Message-----
>> I want to write a small utility which scan the
>> trigger,procedures and views in the RDB$DEPENDENCIES and
>> automatically grant privileges to the objects they access or
>> manipulated.
>> In order to not reinventing the wheel and wasting time, is
>> there such utility freely available?

> There are a couple of procedures at
> which should give you a
> starting point.

I've finished writing the utility with Delphi7. Except of Delphi and
its standard component, the components used are all free component:
UIB, gaSQLParser and SynEdit.

I finally did not use RDB$DEPENDECIES at all because with can
not deduce what privileges should be given. Besides that, I also found
that if a field of the view is obtained by a selectable stored
procedure, the name of the stored procedure is not recorded in the

To obtain all the dependencies and the privileges needed, I parse the
source code of the triggers/sp/views.

I want to make this utility a freeware, but I am still confuse with
the license things. Meanwhile, everybody interested to try this little
program can contact me privately.

On Wednesday, November 2, 2005, 7:01:14 PM, Dimitry Sibiryakov wrote:

> IBExpert includes such functionality. Try google for "auto-grant"
> or "grant manager".

I've downloaded IBExpert, however IBExpert autogrant for
sp/view/trigger can not be run in batch.

Bambang P.

"The bad thing about good things is that they come to an end; and
the good thing about bad things is that they also end." - Annamaria Rabatte Cervi