Granting query monitoring permissions for a user
Users with sys:monitor permission can view all queries. In addition,
users with sys:operator permission can cancel queries, analyze query
history, and perform vacuum operations.
To grant query monitoring permission for a user
-
Enter the following command to provide system monitor access, where user-name is the name of the user for whom you want to provide access.
grant role sys:monitor to "IAM:user-name"; -
(Optional) Enter the following command to provide system operator access, where user-name is the name of the user for whom you want to provide access.
grant role sys:operator to "IAM:user-name";
