1 person found this helpful
Owner of PRODUCTION_VW should have below access to ASW_SCHEMA.HOT_PROD.
grant select on ASW_SCHEMA.HOT_PROD to <owner of PRODUCTION_VW> with grant option;
Once done try below command:
GRANT SELECT ON PRODUCTION_VW TO IMG_USER;
Thanks , it worked
If it worked, then select the answer as CORRECT rather than just helpful.
And it would also help if you change your display name to something meaningful rather than a number, making simpler for everyone to followup a conversation: