Skip site navigation (1) Skip section navigation (2)

Re: privileges

From: Ben Kim <bkim(at)tamu(dot)edu>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: privileges
Date: 2008-08-28 21:51:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Could it be the search path (schema) issue? Just a quick thought...


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(at)postgresql(dot)org)
> To make changes to your subscription:

In response to

pgsql-admin by date

Next:From: steveDate: 2008-08-28 23:10:44
Subject: Re: WAL files during a backup
Previous:From: Steve HoldowayDate: 2008-08-28 21:40:42
Subject: Re: Installing PostgreSQL 8.3.3. on Vista

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group