Re: [Gnumed-devel] adding permissions

[Karsten Hilbert]

> I've been trying to run the test case for gmClinicalRecord.py but having 
> to manually change some permissions.
Try using the test-doc user.

> User is _sjtan and I've tried adding to group gmdoctors and _gmdoctors 
> and granting all on schema public;
If you have this you should be fine:

"sjtan" in
    gm-doctors, gm-public

"_sjtan" in
    gm-doctors, _gm-doctors, gm-public


> what seems to work is granting to specific tables; but now I'm finding I 
> can't update the sequencers.
This may also be an omission on my/our part. It isn't at all
unlikely that we haven't granted permissions on some sequences
to the appropriate groups yet. I usually include such grants
in the SQL scripts whenever I encounter such permission
problems. The main source of the ailing is that PG doesn't
automatically propagate grants on a table to sequences
automatically generated by the respective CREATE TABLE
statement (say, for SERIAL fields).

> So how to add permissions easily?
PG itself doesn't make it particularly convenient,
unfortunately.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346