By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Amazon Redshift JDCB properties difference between UID - User and PWD - Password.

0

Hi, when I try to create connection using JDBC driver of redshift if throws error "The server requested password but no password was provided " when provided username and password information in UID and PWD. But, if I try to create connection by providing same credential in user and password then it works fine.

My jdbc url contains : jdbc:redshift://my_host:5439/dev;ssl=true;tcpKeepAlive=true;sslfactory=com.amazon.redshift.ssl.NonValidatingFactory

Is it something to do with Admin user and password which we provide at the time of creating redshift cluster ?

Can some help me in understanding what is difference between UID & User and PWD & Password.

Do we need to provide any additional information when using UID & PWD?

Below is the link of documentation : https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-configuration-options.html#jdbc20-pwd-option

Thanks.

Topics
Security, Identity, & ComplianceDatabaseAnalyticsNetworking & Content Delivery
Tags
AWS Identity and Access ManagementDatabaseAmazon RedshiftSecurity Group
Language
English
Jeevan08
asked 2 years ago397 views
2 Answers
1

Hi Jeevan,in general,
UID - Redshift DB User name
PWD - Password for the Redshift user UID.
User - Username of the user in your IDP when using IAM authentication (And can be used instead of UID when using standard authentication).
Password - Password of the user in the IDP (And can also be used instead of PWD when using standard authentication)

Ideally, using UID and PWD should work. I would start by checking the JDBC logs (https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-configuring-logging.html#jdbc20-using-log-files) to identify the issue.

AWS
AWS-User-8550001
answered 2 years ago
  • Jeevan08
    2 years ago

    Hi, I did try to logging errors, it seems like driver is taking default properties ie (windows login) . user it taking precedance over UID. UID get's override. Is there any thing like, If we don't provide user, then driver takes our windows login user?

  • AWS-User-8550001
    2 years ago

    No, the UID does not have any default value. Are you trying to use SAML authentication with an IDP? In that case, You would have to verify your driver settings and the settings in your IDP.

0

Hey Jeevan!, Greetings.

Sorry to say, I am not totally aware JDBC connections. But these are few points to help you out:

Hope this helps,

profile picture
sandeepyadav1478
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content