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 個月前檢視次數 55 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南