Hello Francis, Have you checked if this is not a bug?, i haven't use Postgres in a while, but your problem works fine with MySQL. If its a bug then its serious, ordinary users should not be allowed to create databases or tables.
Regards, -- How many people can read hex if only you and dead people can read hex? Follow me on twitter at http://twitter.com/tildemark Visit my website at http://www.tildemark.com On Fri, Sep 11, 2009 at 3:37 PM, Francis Alvin Barretto <[email protected]> wrote: > Hi to all, > > Has anyone tried to create user restriction that will prevent creating > tables for PostgreSql DB? > > Setup: > > Database: users > Database owner: (user_owner) -- with all grant options and privileges. > > Requirement: > Create another user to acess the DB (users) but the restriction should only > allow the user to VIEW and SELECT on the tables. > I already restrict the other requirements but I can't restrict the creation > of table. > > I already tried REVOKE but wala ga work. > > Kinsa naka balo pa help pod. heheh > > > Daghang salamat po. > > _________________________________________________ > 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 > _________________________________________________ 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
