REDSHIFT - Permissions needed to see all users queries

You need to be a superuser to see the queries of other users. see - https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY.html