Hi,
Looks like that fixed it. Thanks! Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center ________________________________ From: Dan Connolly <[email protected]> Sent: Thursday, December 29, 2016 8:46:54 PM To: Pedersen, Jay G; [email protected] Subject: RE: UNMC -- unable to access NAACCR schema in postgresdb on BABEL "Role altered." Try again? -- Dan ________________________________ From: Pedersen, Jay G [[email protected]] Sent: Wednesday, December 28, 2016 3:47 PM To: [email protected]; 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<https://urldefense.proofpoint.com/v2/url?u=https-3A__informatics.gpcnetwork.org_trac_Project_wiki_NAACCR-5FETL&d=DwMFAw&c=ZukO2fIan9e5E9v43wuy1w&r=zM3QQA6OsIJZ5GcDFWgvZrXix6Wvna2i31M0OeLJSrA&m=aqfs0mr9gh_UU3PAQ5z4IOIKyodQYLfywIBGPrceQkU&s=ZlLothStWbpDsEndfVD2ArfmJXhHlyoOYzjVf7IhdwA&e=> 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. 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 [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
