Subject | Re: [firebird-support] Re: stored procedures permissions question |
---|---|
Author | Bogusław Brandys |
Post date | 2005-08-26T20:53:55Z |
Robby wrote:
Could we discuss this proposition ?
Regards
Boguslaw Brandys
> Ok. I knew that that was an option, but I have about 40 SPs....that'sFeature request.Good for developer,but consider possible security problems.
> 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.
Could we discuss this proposition ?
Regards
Boguslaw Brandys