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