user permission denied for schema

From: Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: user permission denied for schema
Date: 2023-01-31 02:08:33
Message-ID: CALXoLqx3we1xWccpkCbbdWeRSrso6W_qQxf3VzdGMWfadAv7sQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am trying to select records from table for other schema but unable to
fetch due to permission denied error

GRANT SELECT ON ALL TABLES IN SCHEMA condenastvms_uat TO edw;

sdp_edw=> select count(*) from condenastvms_uat.activity_logs;

ERROR: permission denied for schema condenastvms_uat

LINE 1: select count(*) from condenastvms_uat.activity_logs;

Regards

Ankur

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Teja Jakkidi 2023-01-31 02:11:21 Re: user permission denied for schema
Previous Message Abhishek Singh 2023-01-30 23:02:32 Re: Foreign key creation on table with huge record count.