使用 AWS re:Post 即表示您同意 AWS re:Post 使用條款
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.

主題
安全性、身分識別與合規資料庫分析網路與內容交付
標籤
AWS Identity and Access Management資料庫Amazon Redshift安全性群組
語言
English
Jeevan08
已提問 1 年前檢視次數 247 次
2 個答案
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
已回答 10 個月前
  • Jeevan08
    10 個月前

    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
    10 個月前

    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
已回答 10 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋，同時有助於提問者的專業成長。

回答問題指南

相關內容