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 자격 증명 및 액세스 관리데이터베이스아마존 Redshift보안 그룹
언어
English
Jeevan08
질문됨 10달 전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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠