Re: [Gnumed-devel] Username

[Karsten Hilbert]

On Thu, Feb 23, 2012 at 11:57:12PM +0000, Jim Busser wrote:

> To look over the list of actually-existing DB accounts, one can login to psql 
> using gm-dbo or any other valid account and then issuing:
> 
>       select rolname, oid, rolcanlogin, rolvaliduntil from pg_roles where 
> substring(rolname for 7) <> 'gnumed_' order by rolsuper desc, rolcreaterole 
> desc, rolcanlogin desc, rolname;
> 
> which (omitting the names of database versions) gives something like
> 
>           rolname     |  oid  | rolcanlogin |     rolvaliduntil      
>       ----------------+-------+-------------+------------------------
>        postgres       |    10 | t           | 
>        gm-dbo         | 16403 | t           | 
>        any-doc        | 16410 | t           | 
>        any-staff      | 69361 | t           | 
>        jabu           | 81511 | t           | 
>        test-doc       | 16411 | t           | 2004-12-31 00:00:00-08
>        test-nurse     | 16412 | t           | 2004-12-31 00:00:00-08
>        test-secretary | 16413 | t           | 2004-12-31 00:00:00-08
>        gm-doctors     | 16397 | f           | 
>        gm-logins      | 16396 | f           | 
>        gm-public      | 16402 | f           | 
>        gm-staff       | 69199 | f           | 
>       (14 rows)

Indeed. Also, the following SQL function makes easier
getting the accounts related to a certain GNUmed database:

        select gm.get_users();                                          -- for 
the logged-on database
        select gm.get_users(<gnumed_vNUMBER>);          -- for the vNUMBER 
database

This is used by the GNUmed backup scripts to learn
of the relevant roles.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346