Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 576DF2E004A for ; Thu, 17 Jan 2008 10:30:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 95991-06 for ; Thu, 17 Jan 2008 10:30:33 -0400 (AST) Received: from web56407.mail.re3.yahoo.com (web56407.mail.re3.yahoo.com [216.252.111.86]) by postgresql.org (Postfix) with SMTP id B5D682E379A for ; Thu, 17 Jan 2008 10:30:38 -0400 (AST) Received: (qmail 88803 invoked by uid 60001); 17 Jan 2008 14:30:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=TJpfU7jQZ/aj0fHF22XcSyGNxY104ZO6mcAZNzdOwp9JAHqr3yeGw93QdufZfyrkyerWO86umHcVACjO+69l0YSy7n6WXmpGKwVfpUfKQEzkm8a9QkueveN2yAIJFBfyKZEiN3beMkaSo9PL7mRav+eZaT36xkEi4wktkOghDc8=; X-YMail-OSG: 5KiN89cVM1kS78UUaHRqPQ5sI6OmBwGQJ7ih1l_BF52eiNUQZNz5d734MzWN5TzKpBn.xqNSOwdgHBLIGJhodtsTIjiNGleobX.NmuABJ6.2PIQlF8iaeRFYWhhvSr9mYHDuk8QK4Bmn50Bp7Z6LQqiL Received: from [198.119.134.32] by web56407.mail.re3.yahoo.com via HTTP; Thu, 17 Jan 2008 06:30:37 PST Date: Thu, 17 Jan 2008 06:30:37 -0800 (PST) From: Jessica Richard Subject: select only user To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-315546726-1200580237=:88733" Content-Transfer-Encoding: 8bit Message-ID: <77335.88733.qm@web56407.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/201 X-Sequence-Number: 27975 --0-315546726-1200580237=:88733 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I created a user and granted only "select" to this user so that this user can only select the tables on a production system. But by default, this user can also CREATE TABLE successfully.... How can I revoke this "create table" privilege (and possible others) and limit this user to only the permissions granted by me? Thanks, Jessica --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --0-315546726-1200580237=:88733 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I created a user and granted only "select" to this user so that  this user can only select the tables on a production system. But by default, this user can also CREATE TABLE successfully....

How can I revoke this "create table" privilege (and possible others) and limit this user to only the permissions granted by me?

Thanks,
Jessica


Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --0-315546726-1200580237=:88733--