On Mon, Jan 10, 2005 at 14:40:46 -0800, Chris <pglist@xxxxxxxxx> wrote: > Basically what I want is to limit a user to not being able to view > certain tables within a schema, in this case the public schema. Say > we have 300 tables in a database but a particular user only needs > access to 3 of them. I don't really want them to even be able to view > all the other tables. Using separate databases isn't possible because > a web application running under mod perl needs access to all the > tables, and I don't want to keep a pool of persistant connections open > for 300+ databases. > > I would rather avoid using schema's to do this if I can, but I think > that's the only way to get what I want. What do you mean by view other tables? You can see metadata for tables in the catalog tables and you can't block access to those without causing problems. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
