如何授予对Amazon Redshift用户的访问权限以读取系统表，视图，日志等? [英] How do I grant access to an Amazon Redshift user to read the system tables, views, logs, etc?

问题描述

我在Amazon Redshift中有一个用户.我希望该用户能够对系统表进行只读查询:

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.

推荐答案

很显然，您不想将超级用户授予其他用户，以便他们可以查看系统日志.能够监控是一个非常常见的用例，不需要授予某人空白权限.

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.

非常感谢您能够使用syslog access选项授予对系统表的访问权限.

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

alter user user123 syslog access unrestricted

请参见有关可见性的Redshift文档

这篇关于如何授予对Amazon Redshift用户的访问权限以读取系统表，视图，日志等?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！