I am new to postgresql and I would grateful if you could please advise on how-to resolve the following error..
I have issued the followed commands:
SELECT sub1.nct_id, sub1.condition, sub1.condition_name,
sub2.overall_status, sub2.participants,
e.criteria,
f.city, f.state, f.country,
i.intervention_type, i.name AS intervention
FROM (SELECT c.nct_id, c.name AS condition, c.downcase_name AS condition_name
FROM ctgov.conditions AS c
-- selecting only cancer trials before joining
WHERE c.name ILIKE '%cancer%') sub1
JOIN (SELECT s.nct_id, s.overall_status, s.enrollment AS participants
FROM ctgov.studies AS s
-- selecting only completed cancer trials before joining
WHERE s.overall_status = 'Completed') sub2
ON sub1.nct_id = sub2.nct_id
JOIN ctgov.eligibilities AS e
ON sub1.nct_id = e.nct_id
JOIN ctgov.facilities AS f
ON sub1.nct_id = f.nct_id
JOIN ctgov.interventions AS i
ON sub1.nct_id = i.nct_id;
And the error is: ERROR: permission denied for schema ctgov SQL state: 42501
Could you please advise on how to setup the privileges to have access to the tables defined in schema?
Thank you in advance!!!