1 Answer
- Newest
- Most votes
- Most comments
0
Only super users can create super users as described in the following document.
https://docs.aws.amazon.com/redshift/latest/dg/r_superusers.html
You must be a superuser to create a superuser.
I think the only way to restore users is to restore Redshift from backup.
If this answer leads to a resolution, please approve the answer for the betterment of the community.
Relevant content
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 days ago
- AWS OFFICIALUpdated a year ago
Thanks - yes, I know that only super users can create other super users from the Docs. I was wondering if it might be possible to restore the underlying users tables / permissions without restoring to a new Cluster...
Or perhaps - can AWS Support add a new user in for me / fix this issue from their side?
You can check with AWS support, but I don't think AWS support will create it for you, as user management is solely the responsibility of the AWS user.