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

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks