How do I grant access to an Amazon Redshift user to read the system tables, views, logs, etc?

Question

I have a user in Amazon Redshift. I want that user to be able to do read-only queries against the system tables:

http://docs.aws.amazon.com/redshift/latest/dg/cm_chap_system-tables.html

But I don't know how to grant a user who is not a superuser access to these tables as it does not appear to be documented anywhere on amazon.

Answer 1

Obviously you don't want to grant superuser to another user just so they can see system logs. Being able to monitor is a very common use case that shouldn't require giving someone carte blanche access.

Thankfully you have the ability to grant access to system tables using the syslog access option.

alter user user123 syslog access unrestricted

See Redshift documentation on visibility