Granting query monitoring permissions for a role - Amazon Redshift

Granting query monitoring permissions for a role

Users with a role that has sys:monitor permission can view all queries. In addition, users with a role that has sys:operator permission can cancel queries, analyze query history, and perform vacuum operations.

To grant query monitoring permission for a role

  1. Enter the following command to provide system monitor access, where role-name is the name of the role for which you want to provide access.

    grant role sys:monitor to "IAMR:role-name";

  2. (Optional) Enter the following command to provide system operator access, where role-name is the name of the role for which you want to provide access.

    grant role sys:operator to "IAMR:role-name";