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
asked 2 months ago49 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions