I have created a database 'datashare_db' from a datashare from another aws account.
This database contains a schema 'datashare_schema'.
Now for granular access purpose, I have created another database 'my_db' and created an external schema 'ds_schema' in it from 'datashare_db'.
The 'ds_schema' contains 'tbl_1'.
I have created a user 'abc_user' and granted him a usage privilege on this 'ds_schema'.
when 'abc_user' is trying to query 'tbl_1' by referencing it as 'select * from my_db.ds_schema.tbl_1', the user is getting as 'my_db.ds_schema.tbl_1 does not exists'.
Any idea, why I am getting this error?