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(at)gmail(dot)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
>
>