Re: System catalog table privileges

On 7/21/06, Hilary Forbes <hforbes(at)dmr(dot)co(dot)uk> wrote:
>
> Aaron
>
> Thanks for this one - I had actually wondered about doing that but the
> trouble is that they say that they need up to the minute reports not "as of
> last night". Indeed, I do have another app where I do just that because I
> find that reports indexes/requirements are very different to transactional
> type requirements. However, you have made me make up my mind to see if I
> can persuade them to work on data that is a day old.
>

I have heard "I need up to the minute data" a lot but have NEVER seen it to
be true. I guess if you are trading stocks on the stock market and need to
buy and sell immediately as the prices change then you would have a reason
but almost always business users think they need things now when they don't.

You could also look at the cost/benefit: if they bring the database down,
how much would it cost the business? If they are working on day old data,
how much would it cost? Get the user to write down and justify their
numbers. This will show to you and the user whether it is really necessary
to report off of the live data.

Good luck!

==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================