Re: [Gnumed-devel] Managing staff (user accounts)

[Karsten Hilbert]

On Sun, May 22, 2011 at 05:18:46PM -0700, Jim Busser wrote:

> >> - how does one (if they know gm-dbo) overwrite or reset a GNUmed user 
> >> password?
> > 
> > This needs action outside the GNUmed client.
> 
> Presumably relates to
> 
>       
> http://publicdb.gnumed.de/~ncq/gnumed/schema/gnumed_v15/gnumed-schema.html#gm.function.create-user-name-text

No. This function creates_users().

> Can it be achieved with gm-dbo?

Yes.

> On my Mac, I changed working directory to
> 
>       
> /opt/local/var/macports/software/postgresql84/8.4.7_0/opt/local/lib/postgresql84/bin
> 
> and did
> 
>       ./psql -d gnumed_v15 -U gm-dbo
> 
> and got
> 
>       gnumed_v15=>
> 
> and tried
> 
>       ALTER USER any-doc WITH ENCRYPTED PASSWORD 'any-doc2';
> 
> and got
> 
>       ERROR: syntax error at or near "any"
>       LINE 1: ALTER USER any-doc WITH ENCRYPTED PASSWORD 'any-doc2'; 
>       (it did not like the hyphen after "any")

You need to quote:

        ALTER USER "any-doc" WITH ENCRYPTED PASSWORD 'any-doc2';

or else PostgreSQL will try to subtract "doc" from "any"
which won't work.

> So is any-doc not an actual postgres database user, just a value in a table 
> used by the GNUmed application?

No, it's the database user.

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