[Gnumed-devel] adding permissions

[syan tan]

I've been trying to run the test case for gmClinicalRecord.py but having 
to manually change some permissions.
User is _sjtan and I've tried adding to group gmdoctors and _gmdoctors 
and granting all on schema public;
what seems to work is granting to specific tables; but now I'm finding I 
can't update the sequencers.

So how to add permissions easily?

2003-10-13 21:42:26 [DATA]  (../python-common/gmPG.py::__pgconnect:468): 
setting session to [READ ONLY] for address@hidden:gnumed
2003-10-13 21:42:26 [DATA]  
(../python-common/gmPG.py::GetConnection:168): requesting RO connection 
to service [historica]
2003-10-13 21:42:26 [DATA]  
(../python-common/gmPG.py::GetConnection:176): using service [default] 
instead of [historica]
2003-10-13 21:42:26 [DATA]  
(../python-common/gmPG.py::GetConnection:168): requesting RO connection 
to service [personalia]
2003-10-13 21:42:26 [DATA]  
(../python-common/gmPG.py::GetConnection:176): using service [default] 
instead of [personalia]
2003-10-13 21:42:26 [DATA]  
(gmClinicalRecord.py::_create_health_issue:476): health issue 
[__default__] does not exist for patient [1]
2003-10-13 21:42:26 [DATA]  
(../python-common/gmPG.py::GetConnection:164): requesting RW connection 
to service [historica]
2003-10-13 21:42:26 [WARN]  (../python-common/gmPG.py::__pgconnect:445): 
client encoding not specified, this may lead to data corruption in some 
cases
2003-10-13 21:42:26 [DATA]  (../python-common/gmPG.py::__pgconnect:468): 
setting session to [READ WRITE] for address@hidden:gnumed
2003-10-13 21:42:26 [WARN]  (../python-common/gmPG.py::run_query:588): 
query >>>insert into clin_health_issue (id_patient, description) values 
(%s, %s)<<< with args >>>(1, '__default__')<<< failed
2003-10-13 21:42:26 [WARN]  (../python-common/gmPG.py::run_query:588): 
exception type : libpq.OperationalError
2003-10-13 21:42:26 [WARN]  (../python-common/gmPG.py::run_query:588): 
exception value: ERROR:  audit_fields_pk_audit_seq.nextval: you don't 
have permissions to set sequence audit_fields_pk_audit_seq

2003-10-13 21:42:26 [DATA]  (../python-common/gmPG.py::run_query:588): 
Traceback (most recent call last):<#10-0x0A-lf>
2003-10-13 21:42:26 [DATA]  (../python-common/gmPG.py::run_query:588):   
File "../python-common/gmPG.py", line 586, in run_query<#10-0x0A-lf>    
aCursor.execute(aQuery, *args)<#10-0x0A-lf>
2003-10-13 21:42:26 [DATA]  (../python-common/gmPG.py::run_query:588):   
File "/usr/lib/python2.2/site-packages/pyPgSQL/PgSQL.py", line 2956, in 
execute<#10-0x0A-lf>    raise OperationalError, msg<#10-0x0A-lf>
2003-10-13 21:42:26 [DATA]  (../python-common/gmPG.py::run_query:588): 
OperationalError: ERROR:  audit_fields_pk_audit_seq.nextval: you don't 
have permissions to set sequence 
audit_fields_pk_audit_seq<#10-0x0A-lf><#10-0x0A-lf>
2003-10-13 21:42:26 [ERROR] 
(gmClinicalRecord.py::_create_health_issue:483): cannot insert health 
issue [__default__] for patient [1]
2003-10-13 21:42:26 [ERROR] 
(gmClinicalRecord.py::__load_default_health_issue:459): cannot load 
default health issue for patient [1]
~
~