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


From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: privileges
Date: 2008-08-28 20:37:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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.




pgsql-admin by date

Next:From: Richard BroersmaDate: 2008-08-28 20:49:17
Subject: Re: privileges
Previous:From: Andrew SullivanDate: 2008-08-28 17:47:12
Subject: Re: Dumping/Restoring with constraints?

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