Hi francis, On Fri, Sep 11, 2009 at 7:37 PM, Francis Alvin Barretto <[email protected]> wrote:
> Has anyone tried to create user restriction that will prevent creating > tables for PostgreSql DB? there is a good mailing list thread on this: http://markmail.org/message/a7kgu2b44b65edav the procedure isn't trivial, unfortunately. you can do it, but you need to do a lot of things, because there are many side effects (e.g., revoke all on schema public from public will do what you want but it will break a lot of other permissions, so you'd then want to grant access to schema public selectively. good luck, and if you come up with a simple and *complete* solution, it'd be great if you wrote it up on a blog so others can benefit. tiger -- Gerald Timothy Quimpo http://bopolissimus.blogspot.com [email protected] [email protected] Public Key: "gpg --keyserver pgp.mit.edu --recv-keys 672F4C78" Usually, a very large amount of work goes into the parsing step (Perl and C++ are probably the best examples of this-both are basically unparseable.) _________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://lists.linux.org.ph/mailman/listinfo/klug) Searchable Archives: http://archives.free.net.ph
