Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary

2005-05-14 Thread Christopher Kings-Lynne
Tom mentioned that he had not had these security concerns raised before. From my point of view I just have no idea about the level of information offered to any given user and am scared to run PostgreSQL in an ISP shared environment because of it. I am sure I can secure people from connecting

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary

2005-05-14 Thread Stephen Frost
* Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote: It bothers me a great deal that I can't control very easily what a given user can see when they connect over ODBC or via phppgadmin in terms of schemas, tables and columns. I fixed this in application code in phppgadmin but that's clearly

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary

2005-05-14 Thread Jim C. Nasby
On Sat, May 14, 2005 at 08:55:17AM -0400, Stephen Frost wrote: * Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote: It bothers me a great deal that I can't control very easily what a given user can see when they connect over ODBC or via phppgadmin in terms of schemas, tables and columns. I

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary

2005-05-14 Thread Stephen Frost
* Jim C. Nasby ([EMAIL PROTECTED]) wrote: On Sat, May 14, 2005 at 08:55:17AM -0400, Stephen Frost wrote: * Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote: Hackers - we get an email about information hiding in shared postgresql/phppgadmin installations at least once a fortnight :)

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary

2005-05-14 Thread Jim C. Nasby
On Sat, May 14, 2005 at 10:00:09AM -0400, Stephen Frost wrote: * Jim C. Nasby ([EMAIL PROTECTED]) wrote: On Sat, May 14, 2005 at 08:55:17AM -0400, Stephen Frost wrote: * Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote: Hackers - we get an email about information hiding in shared

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary of Arguments

2005-05-13 Thread Josh Berkus
Andrew, It might be safer, but that doesn't hit my target at all. I am aiming at a zero-knowledge user, i.e. one who cannot discover anything at all about the db. The idea is that even if subvert can subvert a client and get access to the db the amount of metadata they can discover is as

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary of Arguments

2005-05-13 Thread Andrew - Supernews
On 2005-05-13, Josh Berkus josh@agliodbs.com wrote: Andrew, It might be safer, but that doesn't hit my target at all. I am aiming at a zero-knowledge user, i.e. one who cannot discover anything at all about the db. The idea is that even if subvert can subvert a client and get access to the db

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary

2005-05-13 Thread Andrew Dunstan
Andrew - Supernews wrote: 1) The ISP case, where you want to hide all catalog information from the users except the database owner or superuser. I don't believe this is ever feasible in practice, since client interfaces at any level higher than libpq will need to access metadata

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary

2005-05-13 Thread Russell Smith
On Sat, 14 May 2005 04:34 am, Andrew Dunstan wrote: Andrew - Supernews wrote: 1) The ISP case, where you want to hide all catalog information from the users except the database owner or superuser. I don't believe this is ever feasible in practice, since client interfaces at

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary

2005-05-13 Thread Alvaro Herrera
On Sat, May 14, 2005 at 12:25:01PM +1000, Russell Smith wrote: - Which parts of other databases can be seen by users? The name, username of the owner, etc. No table names, for example. The user list is also visible to everyone, across databases. - What is the best method to restrict

Re: [HACKERS] Catalog Security WAS: Views, views, views: Summary

2005-05-13 Thread Stephen Frost
* Russell Smith ([EMAIL PROTECTED]) wrote: Tom mentioned that he had not had these security concerns raised before. From my point of view I just have no idea about the level of information offered to any given user and am scared to run PostgreSQL in an ISP shared environment because of