Search Postgresql Archives

Re: giving users access to specific databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



postgresql@xxxxxxxxx wrote:
you should play around with phpPgAdmin for a while and let us know
specifically what we can help you with.
    

  
in pg_hba.conf you can set it so that users have access to any database if they are in a group (or do we say "role" now?) that has the same name as the database.

This is nifty because it lets you control everything after editing pg_hba.conf only once.  For each database create a group of the same name. Give users access by putting them into the group, revoke access by taking them out.

I also generally grant that particular group NO permissions, actual permissions to work with tables are granted by membership in more specialized groups.

I've managed to figure out how to fix most of my user access problems, but
I'm still having trouble limiting the list of databases users see when they
log in through phpPgAdmin.

I noticed in the config.inc.php file that I can set a user's view to only
show the databases that they own (via the $conf['owned_only'] = true;
parameter).  What I would like to do is limit the users to seeing the
databases for which they are a user for.  For example I would like to set a
parameter that was something like $conf['user_only'] = true.  This will be
particularly helpful for double checking which users have access to what
databases and also to eliminate confusion for less technically adept users
who would have to wade through all sorts of databases owned by other people
on the shared server my hosting company provides.

Thanks,
Courtenay


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
  

begin:vcard
fn:Kenneth  Downs
n:Downs;Kenneth 
email;internet:ken@xxxxxxxxxx
tel;work:631-689-7200
tel;fax:631-689-0527
tel;cell:631-379-0010
x-mozilla-html:FALSE
version:2.1
end:vcard


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux