I am looking to implement a rotating password script for a particular guest user.
Trying to avoid the XML API which I am not familiar with, SQL would be a piece of cake.
So looks like I need to modify tipsDB -> cpg_nwamdpsuser. But the perms are:
ALTER TABLE cpg_nwamdpsuser OWNER TO postgres;
GRANT ALL ON TABLE cpg_nwamdpsuser TO postgres;
GRANT SELECT ON TABLE cpg_nwamdpsuser TO appuser;
GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE cpg_nwamdpsuser TO appadmin;
However appadmin isn't allowed to login externally via pg_hba.conf.