{"provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/yohei-a/","height":"190","version":"1.0","title":"Redshift \u3067 superuser \u6a29\u9650\u3092\u4ed8\u4e0e\u305b\u305a\u306b sys_connection_log \u306b\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u3059\u308b\u305f\u3081\u306b\u306f\u3001sys:monitor \u30ed\u30fc\u30eb\u3092\u4ed8\u4e0e\u3059\u308c\u3070\u3088\u3044","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20251212%2F1765512177\" title=\"Redshift \u3067 superuser \u6a29\u9650\u3092\u4ed8\u4e0e\u305b\u305a\u306b sys_connection_log \u306b\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u3059\u308b\u305f\u3081\u306b\u306f\u3001sys:monitor \u30ed\u30fc\u30eb\u3092\u4ed8\u4e0e\u3059\u308c\u3070\u3088\u3044 - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","width":"100%","blog_url":"https://yohei-a.hatenablog.jp/","blog_title":"ablog","published":"2025-12-12 13:02:57","categories":["AWS","Redshift"],"author_name":"yohei-a","type":"rich","url":"https://yohei-a.hatenablog.jp/entry/20251212/1765512177","description":"Redshift \u3067 superuser \u6a29\u9650\u3092\u4ed8\u4e0e\u305b\u305a\u306b sys_connection_log \u306b\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u3059\u308b\u305f\u3081\u306b\u306f\u3001sys:monitor \u30ed\u30fc\u30eb\u3092\u4ed8\u4e0e\u3059\u308c\u3070\u3088\u3044 \u30e6\u30fc\u30b6\u30fc\u4f5c\u6210 dev=# create user test_monitor password 'xxx'; CREATE USER dev=# \\q \u65b0\u30e6\u30fc\u30b6\u30fc\u3067 sys_connection_log \u306b\u30a2\u30af\u30bb\u30b9 $ psql -h dwh-cluster-ads-test.********.ap-northeast-1.redshift.amazonaws.com -p 5439 -d dev -U test_moni\u2026"}