Objects in external schema are not visible

0

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?

Amrut_B
질문됨 3달 전54회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠