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

[Jim Busser]

On 2011-05-22, at 1:48 PM, Karsten Hilbert 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

Can it be achieved with gm-dbo? 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")

and in case the above for for postgres earlier than 8.4 I tried according to

        http://www.postgresql.org/docs/8.4/static/sql-alterusermapping.html

i.e.

        ALTER USER MAPPING FOR any-doc OPTIONS (password 'any-doc2');

but still it did not like the "a" in any-doc

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

-- Jim