From: Ben Kim <bkim@tamu.edu>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: privileges
Date: Thu, 28 Aug 2008 16:51:28 -0500 (CDT)
Message-ID: <Pine.GSO.4.64.0808281650520.7938@coe.tamu.edu> (raw)
In-Reply-To: <12A73542-D0FE-4643-B2E4-BA546A7C5C04@indiana.edu>
References: <12A73542-D0FE-4643-B2E4-BA546A7C5C04@indiana.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bkim@tamu.edu, walterc@indiana.edu
Subject: Re: privileges
In-Reply-To: <Pine.GSO.4.64.0808281650520.7938@coe.tamu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox