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.
Redshift - How to grant user permission to SELECT from a view without granting access to the underlying external tableasked a month ago
Redshift superuser permission denied to STL tablesAccepted Answerasked 4 months ago
DMS 3.4.7 Fails on some tables upload to Redshift : Access denied to KMS keyasked a month ago
RDSADMIN_UTIL: what syntax to grant a system privilege?asked 5 months ago
How to give users a limited access time to a web app running on ECS/EC2asked 4 months ago
Redshift - Grant users access to system tables
Redshift Maximum tables limit exceeded problem, how to prevent this behaviorasked 2 months ago
Are you able to hide tables in a database using Lake Formation Taggingasked 4 months ago
Redshift Datashare: Grant CREATE DATASHARE permissions to usersAccepted Answer
How to grant users read only permission to AthenaAccepted Answerasked 2 years ago