Databases owned by roles

2011-10-24
2013-06-11
  • Malcolm Scott
    Malcolm Scott
    2011-10-24

    Hi all,

    I'd like to use $conf to avoid other users' databases appearing when a user logs in.  However most of the databases on my server are not directly owned by the end user, but by roles which are delegated to the end user.  These databases don't show up when using owned_only.

    E.g.:

    CREATE ROLE mas90 LOGIN;
    CREATE ROLE foo NOLOGIN;
    GRANT foo TO mas90;
    CREATE DATABASE foo OWNER foo;
    CREATE DATABASE bar OWNER someOtherUser;
    

    When I log in to phpPgAdmin as mas90, I want to see database foo but not bar.

    I suspect this will be a fairly simple change, but is anyone already intending to do this?

    Thanks!

    Malcolm

     
  • Sandy
    Sandy
    2011-12-14

    I have a similar request, I would like to display the database and the schema that a user belongs to and has access/edit rights in the database.

    For example:

    We have a database for our second year students, they each have a schema that grants a set of privileges on the database (table creation etc).  There are in excess 100 students who have access and we decided that it would be easier to maintain a single database and a set of schemas.

    Is there a similar $conf that would say $conf

    Regards,

    Sandy Spence