Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Windows Authentication for Oracle

ketan.avalaskarJul 22 2019 — edited Aug 14 2019

I wanted to use windows authentication for oracle database .

As mentioned in different links I created user OPS$SURUCHI and on windows machine I create a user SURUCHI with Password.

here is the screenshot which says that the operating user has been created successfully.

pastedImage_0.png

I granted the permissions CREATE SESSION, CONNECT, DBA ,RESOURCE to the user .

After that I logged in the machine with the user SURUCHI.

I set the Services_NAMES and then try the command SQLPLUS /.

As shown in the screenshot I am getting error invalid username/password

pastedImage_1.png

Please let me know how to make it successful.

Also help us how we perform windows authentication using SQL Developer..

We would also like to know what should be the jdbc url when we have windows authentication
This post has been answered by Sunny kichloo on Jul 22 2019
Jump to Answer

Comments

Post Details

Added on Jul 22 2019
#general-database-discussions
16 comments
1,432 views