Re: [ppa-users] adv_auth config question

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

This is actually a problem on the postgres side of things...  

First off... postgres does not allow you to setup permissions on databases 
themselves... only the objects within the database (tables, views, etc).  So 
there are no permissions directly attached to the database other than those 
associated with who is the owner/creator of the database.

You probably have your pg_hba.conf file set with "sameuser" authentication.  
This only allows the user to connect to a database with the same exact 
username with which they are logged in.  In addition, you have cfgUserDatabase 
set to true in phpPgAdmin's config.inc.php. This makes it so the databases 
listed on the left side will only be the databases that the user can connect 
to.

You can correct it by changing the phpPgAdmin setting, or by changing your 
authentication in pg_hba.conf.

-Dan

Quoting Andrew Neuschwander <an...@nt...>:

> Using adv_auth, I can't get databases which are not owned by a user to show
> 
> up on their menu even when they have privileges on that database.
> 
> I have a database owned by the postgres user. I then grant 
> select/update/insert privileges to a group. I then add several users to that
> 
> group. These users don't see the database. Does phpPgAdmin lack this
> ability?
> 
> Thanks in Advance,
> -Andrew
> -- 
> Andrew A. Neuschwander - an...@nt...
> UNIX/Linux Systems, NASA Science Compute Facility
> NTSG, School of Forestry, The University of Montana
> http://www.ntsg.umt.edu - (406) 243 - 6310
> 
> _______________________________________________
> phpPgAdmin-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
>