SVV_REDSHIFT_TABLES returns empty results when queried via a NON-ADMIN USER with SYSLOG ACCESS UNRESTRICTED

One of our monitoring systems uses SVV_REDSHIFT_TABLES to identify the user tables across all databases.

When SVV_REDSHIFT_TABLES is queried using a non-admin user created with SYSLOG ACCESS UNRESTRICTED, no results are returned.

The SVV_REDSHIFT_TABLES doc points to Visibility of data in system tables and views which further points to https://repost.aws/knowledge-center/amazon-redshift-system-tables.

The above re:post states creating a user with SYSLOG ACCESS UNRESTRICTED grants them access to all rows in the metadata views.

Even after creating the user with SYSLOG ACCESS UNRESTRICTED rows are not visible from SVV_REDSHIFT_TABLES.

Meta info

select VERSION();
+-------------------------------------------------------------------------------------------------------------------------+
|version                                                                                                                  |
+-------------------------------------------------------------------------------------------------------------------------+
|PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.63269|
+-------------------------------------------------------------------------------------------------------------------------+

Provisioned Cluster with "ra3.xlplus" instance type 

Steps to reproduce the issue

Create databases using admin credentials

create database user_access_test_db_1;
create database user_access_test_db_2;

Connect to Redshift with "user_access_test_db_1" as the database in the connection string and create a table using admin credentials

create table user_access_test_db_1.public.test_table_1 as
select 'test_table_1_row_1'
union
select 'test_table_1_row_2'
union
select 'test_table_1_row_3'
union
select 'test_table_1_row_4';

Connect to Redshift with "user_access_test_db_2" as the database in the connection string and create a table using admin credentials

create table user_access_test_db_2.public.test_table_2 as
select 'test_table_2_row_1'
union
select 'test_table_2_row_2'
union
select 'test_table_2_row_3'
union
select 'test_table_2_row_4';

Create a user using admin credentials

CREATE USER user_access_test_user PASSWORD <password> SYSLOG ACCESS UNRESTRICTED;
ALTER USER user_access_test_user WITH SYSLOG ACCESS UNRESTRICTED;

Connect to Redshift with "user_access_test_db_2" as the database in the connection string and create a table using "user_access_test_user" credentials

select *
from SVV_REDSHIFT_TABLES
where database_name in ('user_access_test_db_1', 'user_access_test_db_2')
  and schema_name not in ('pg_catalog', 'information_schema', 'pg_internal')

-- Returns no result