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

Another permissions question

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Another permissions question
Date: 2008-08-27 17:38:45
Message-ID: 9093C7AE-EFFF-4326-8BC1-34A672169A84@indiana.edu (view raw or flat)
Thread:
Lists: pgsql-admin
Greetings,

I'm running PostgreSQL 8.2.3 in a zone on a Solaris 10 box.  This is  
an academic environment, so the way we usually do things is to set up  
a database with the students username owned by the student.  There  
are cases where we have faculty research databases.  They are named  
for the project and database and tables are owned by postgres.   
Because I have to set up student databases and occasionally have to  
test how things work, I have a database with my user name that I  
own.  We put up a new server on a solaris 10 zone for a faculty  
research project.  I created the database with postgres as the owner  
and the owner of all the tables on our database server.   The new  
server is where apache and php with run.  I tested and from the new  
server I can connect to the database using psql.  I can't, however,  
once connect see any of the tables.  I changed the privileges on my  
personal database to match the ones on this research database and I  
can still see and browse those tables.  Any ideas?

Thanks,
Carol Walter

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-08-27 17:41:56
Subject: Re: Dumping/Restoring with constraints?
Previous:From: Lee, MijaDate: 2008-08-27 17:34:46
Subject: Unexpected data beyond EOF error

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