[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Managing staff (user accounts)
From: |
Jim Busser |
Subject: |
Re: [Gnumed-devel] Managing staff (user accounts) |
Date: |
Sun, 22 May 2011 17:18:46 -0700 |
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
- [Gnumed-devel] Managing staff (user accounts), Jim Busser, 2011/05/22
- Re: [Gnumed-devel] Managing staff (user accounts), Karsten Hilbert, 2011/05/22
- Re: [Gnumed-devel] Managing staff (user accounts),
Jim Busser <=
- Re: [Gnumed-devel] Managing staff (user accounts), Karsten Hilbert, 2011/05/24
- Re: [Gnumed-devel] Managing staff (user accounts), Jim Busser, 2011/05/24
- Re: [Gnumed-devel] Managing staff (user accounts), Karsten Hilbert, 2011/05/24
- Re: [Gnumed-devel] Managing staff (user accounts), Jim Busser, 2011/05/24
- Re: [Gnumed-devel] Managing staff (user accounts), Karsten Hilbert, 2011/05/25
- Re: [Gnumed-devel] Managing staff (user accounts), Jim Busser, 2011/05/25
- Re: [Gnumed-devel] Managing staff (user accounts), Karsten Hilbert, 2011/05/25
- Re: [Gnumed-devel] Managing staff (user accounts), Karsten Hilbert, 2011/05/24
- Re: [Gnumed-devel] Managing staff (user accounts), Jim Busser, 2011/05/25
- Re: [Gnumed-devel] Managing staff (user accounts), Karsten Hilbert, 2011/05/25