"Role altered." Try again?
-- Dan ________________________________ From: Pedersen, Jay G [jay.peder...@unmc.edu] Sent: Wednesday, December 28, 2016 3:47 PM To: gpc-dev@listserv.kumc.edu; Dan Connolly; Pedersen, Jay G Subject: UNMC -- unable to access NAACCR schema in postgresdb on BABEL Hi, I am trying to update the UNMC NAACCR extract to match as closely as possible to KUMC's NAACCR extract (hopefully exactly), following the procedure outlined here: https://informatics.gpcnetwork.org/trac/Project/wiki/NAACCR_ETL I am attempting to extract the t_item, t_code and t_section tables from the NAACCR schema in the postgres DB in BABEL, as documented. I am able to access the postgres database, and have access to the i2b2metadata schema, but not the naaccr schema. The error I receive ===> ERROR: permission denied for schema naaccr LINE 1: ...ODEDCRP","CODENOTE","CODENOTE2","MODIFYDATE" FROM "naaccr"."... NOTE: my username is "jpedersen" on BABEL Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev