Managing superusers
A superuser allows you to get all the access on Amazon Redshift, independent of all permission checks, and is used for administrative tasks. For example, you can create other users, execute diagnostic queries on system tables, and take action as needed. Superuser access has to be granted sparingly; do not use this for day-to-day work.
The masteruser is a special type of superuser that you set up when launching the cluster.
Getting ready
To complete this recipe, you will need the following setup:
- An IAM user with access to Amazon Redshift
- An Amazon Redshift cluster deployed in AWS Region
eu-west-1 - Amazon Redshift cluster masteruser credentials
- Access to any SQL interface such as a SQL client or the Amazon Redshift Query Editor
How to do it
In this recipe, we will illustrate how to create a superuser and use it to list all the active SQL statements, and demonstrate how to terminate a particular statement:
- Connect to...
