The following command will allow a user to see ALL rows in pg_catalog views and tables (not just their own). By default only a super user can see all rows. This is a way to grant access to all rows without granting superuser.
ALTER USER <USERNAME> SYSLOG ACCESS UNRESTRICTED
https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_USER.html
The following view will show who has unrestricted syslog access: SVL_USER_INFO
Has the column: syslogaccess
select * from SVL_USER_INFO order by usename;
https://docs.amazonaws.cn/en_us/redshift/latest/dg/r_SVL_USER_INFO.html