Thread: user permission denied for schema

Hello Kaushik,

Did you grant usage on schema to the user??

Grant usage on schema schemaname to username;

Thanks,

Teja. J.

On Jan 30, 2023, at 6:08 PM, Ankur Kaushik <ankurkaushik@gmail.com> wrote:



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