You can also use your database application to programmatically call the GetClusterCredentials action, retrieve database user credentials, and connect to the database. They do so by retrieving the database user credentials and establishing a connection between your SQL client and your Amazon Redshift database.
#Redshift create user super drivers#
We can configure our SQL client with Amazon Redshift JDBC or ODBC drivers that manage the process of calling the GetClusterCredentials action. To better manage the access as an alternative to maintaining these credentials we can configure our systems to permit users to create user credentials and log on to the database based on their IAM credentials on the go.Īmazon Redshift provides the GetClusterCredentials API action to generate temporary database user credentials. Both these options require you to maintain passwords somewhere which is not always the best way to do. pgpass ) in the user’s home directory with psql queries. In this article, I am going to show you how we can achieve that in a Redshift database hosted in Amazon cloud.Ĭommonly, Amazon Redshift users log on to the database by providing a database username and password or use a password file (.
It should be the same with the databases that store our most valuable and secure information. Apart from the tremendous convenience they offer, they also offer the highest level of security with no longer needing to type in a passcode and worrying about someone watching us over the shoulders. I know we are living in a world where phones and other devices with advanced biometric authentication have been increasingly becoming a norm.
0 kommentar(er)
