En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

How can I create a new Admin User in Redshift without access to any SuperUser accounts

0

I have accidentally removed the SUPER USER account that I use to run admin tasks with. This is the only admin user for the Redshift cluster, apart from the default rdsdb user.

Logged in as this admin account - I ran the following statement:

ALTER USER {admin_user} NOCREATEUSER;

And now I cannot add new Super Users - as this admin user no longer has this permission.

So - Whats the best solution? I do have snapshot backups from before my mistake, and I can restore one of those to another Cluster, but I would prefer to get back into the existing cluster if possible!

Sujets
Analytique
Balises
Amazon Redshift
Langue
English
rePost-User-4411835
demandé il y a un an1739 vues
1 réponse
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.

profile picture
EXPERT
Riku_Kobayashi
répondu il y a un an
  • rePost-User-4411835
    il y a un an

    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?

  • Riku_Kobayashi EXPERT
    il y a un an

    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.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents