Re: System catalog table privileges

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!