1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
Currently, only users who have the ALTER and SHARE privileges can see the shares that they have privileges for. Therefore, SVV_DATASHARE_OBJECTS result is empty for any user that doesn't have permission on datashare, even with permission SYSLOG ACCESS UNSRESTRICTED.
As superuser, you can grant SHARE on the datashare to the user in order for the user to access the views.
Example: grant share on datashare <datashare_name> to <user_name>;
Once this is granted, the user should be able to view the data in SVV_DATASHARE_OBJECTS only for the datashares where access is granted.
One other workaround is to copy the data from SVV_DATASHARE_OBJECTS to a user table and grant SELECT access on this user table to the user.
관련 콘텐츠
- AWS 공식업데이트됨 2년 전
Is there a way to do this for cross-account datashares? Im my case, I have a datashare from AWS Account 1(Producer) thats accessible on AWS Account 2(Consumer). Running the below on Account 2 returns an error about the datashare not existing;
grant share on datashare <datashare_name> to <user_name>;