I think you sent this to the wrong guy. I just joined Firebird Support
today.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Boguslaw Brandys
Sent: Friday, August 26, 2005 3:54 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: stored procedures permissions
question

Robby wrote:

> Ok. I knew that that was an option, but I have about 40 SPs....that's
> a lot of permissions to grant (considering that I have to do one on a
> case by case basis ...SP Foobar() might require SELECT access to table
> BLA and UPDATE access to table FOO, a different SP would have
> different needs). I see that there are some scripts that can ease
> this, but what would be best is if those SPs ran as sysdba and I only
> had to grant access to the test user to run the SPs.

Feature request.Good for developer,but consider possible security
problems.
Could we discuss this proposition ?

Regards
Boguslaw Brandys



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links