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
> http://www.fbtalk.net/viewtopic.php?id=128 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
RDB$DEPENDENCIES table.

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