Are there tools available which makes Redshift user management easier

Question

Hello,

I found the queries which allows me to add users, roles and grant access to tables etc. However I want have a more automated process so we don't forget steps while e.g. dropping a user/role that all relations for that user/group are beeing revoked before dropping etc. I found this tool [https://github.com/henryivesjones/redshift-user-manager/tree/main]() which works fine for users, but since I have roles (connected to Azure Active Directory groups) this tool doesn't work for me since it doesn't support that.

I already looked around but could not find some alternative tools that will help managing users and their connected privileges. Does anyone know if something like this exists or that you have to build it yourself?

René

Answer

Hi ,
indeed we do not have a service that manages the rights at the data level (tables, column, rows, ...).
I can suggest Satori, an AWS partner running a solution as SaaS which has quite robust track record  : https://satoricyber.com/redshift-security/redshift-security/
We published a blogpost on the solution which details quite well what to expect : https://aws.amazon.com/blogs/big-data/accelerate-amazon-redshift-secure-data-use-with-satori-part-1/

Are there tools available which makes Redshift user management easier

Relevant content