Tuesday, November 2, 2021

script to create database user in aws Redshift database with IAM authentication

 script to create database  user in aws Redshift database with IAM authentication

authentication will be done using the Single sign on thru IAM and DB access will be done through group .


create user  "ABC.123@domain.com" password disable valid until '31-Aug-2022';


alter group  redshift_readwrite_dev add user "ABC.123@domain.com" ;


No comments:

Post a Comment