Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9AB9A64FFE8 for ; Thu, 28 Aug 2008 18:57:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31979-02 for ; Thu, 28 Aug 2008 18:56:58 -0300 (ADT) X-Greylist: delayed 00:05:29.58288 by SQLgrey-1.7.6 Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id 2CA6564FD09 for ; Thu, 28 Aug 2008 18:57:02 -0300 (ADT) Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p3+Sun/8.12.11) with ESMTP id m7SLpSI15565; Thu, 28 Aug 2008 16:51:28 -0500 (CDT) Date: Thu, 28 Aug 2008 16:51:28 -0500 (CDT) From: Ben Kim To: Carol Walter cc: pgsql-admin@postgresql.org Subject: Re: privileges In-Reply-To: <12A73542-D0FE-4643-B2E4-BA546A7C5C04@indiana.edu> Message-ID: References: <12A73542-D0FE-4643-B2E4-BA546A7C5C04@indiana.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/226 X-Sequence-Number: 30071 Could it be the search path (schema) issue? Just a quick thought... Regards, Ben Kim On Thu, 28 Aug 2008, Carol Walter wrote: > Hello, > > I asked this question yesterday, but perhaps I did so in an unintelligible > way. I didn't get any answer that time. Someone usually answers my > questions, so I must not have asked it very well. I have a new database that > I'm building for a faculty research project. I created a role called > app_admin. I granted the app_admin role to my user name. When I try to > describe the table using the "\d" psql command, it tells me there are no > relations. When I issue that command logged as postgres instead of my > username, all the tables are listed. Since this is a new server, I thought > perhaps the database connection wasn't right but I can change to another > database that I have privileges to and I can describe the tables in that > database just fine. > > Please help me with this. I have listed the privileges with the "\z" and it > shows me that my app_admin roles has all privs to all tables and sequences. I > tried to grant the role to my username, thinking that it might not have worked > the first time. The system says that that username already has that role, so > that's not the problem. > > Thanks, > > Carol > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin