Re: [SQL] System catalog table privileges

2006-07-24 Thread Aaron Bono
On 7/21/06, Hilary Forbes <[EMAIL PROTECTED]> 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

Re: [SQL] System catalog table privileges

2006-07-21 Thread Scott Marlowe
On Fri, 2006-07-21 at 11:19, Hilary Forbes 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 tha

Re: [SQL] System catalog table privileges

2006-07-21 Thread Hilary Forbes
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 transacti

Re: [SQL] System catalog table privileges

2006-07-21 Thread Tom Lane
Hilary Forbes <[EMAIL PROTECTED]> writes: > Next question on privileges!  Can I safely remove all privileges > from the system catalog tables for a user Various people have experimented with doing that, but it tends to break a lot of stuff. I suggest you just revoke privileges on the tables you d

Re: [SQL] System catalog table privileges

2006-07-21 Thread Aaron Bono
On 7/21/06, Hilary Forbes <[EMAIL PROTECTED]> wrote: Dear All Next question on privileges!  Can I safely remove all privileges from the system catalog tables for a user and still enable them to select from the public schema?  I guess the real question is what access rights does an ordinary user ha

[SQL] System catalog table privileges

2006-07-21 Thread Hilary Forbes
Dear All Next question on privileges!  Can I safely remove all privileges from the system catalog tables for a user and still enable them to select from the public schema?  I guess the real question is what access rights does an ordinary user have to have to the system catalog tables in order for