Re: [ppa-users] (no subject)

[Dan W. <kil...@us...>]

: On Wed, 20 Feb 2002, Dan Wilson wrote:
:
: > What is the result when they login?  Does it give an error or does it
just
: > not let them in?
:
: the result is that they see no databases at all
:
: >
: > If they can get in from psql and not through phpPgAdmin, then there is a
: > permissions issue, however it might not be in the pg_hba.conf file.
That is
: > one possibility, the other is with the actual permissions (ownership) on
the
: > databases.
:
: yes, database is created and owned by my user, not postgres
:
: shall I change?

Depends... when you men "my user" do you mean your super-user account, or
the user account which is having the permissions problem?

If it's the former, then yes, you need to change the owner of the db... with
the settings you have, in order for the user to see their database, they
have to be the owner.  The best way to do this is by logging in as the user
in question and create the database under their account.  You must give them
create_db permissions, but can remove them after the database is created.

-Dan