OraFAQ Forum: Security » Remote connection without Password

Home » RDBMS Server » Security » Remote connection without Password (oracle 12c Windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Remote connection without Password [message #670746]

Tue, 24 July 2018 02:19

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi,

Recently we have changed the password of SYS, SYSTEM users through.

ORAPWD as well as ALTER USER ....

All the servers are asking the new password while connecting remotely,
but only one server is connecting without password.

Here is the settings.

SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)

remote_login_passwordfile string EXCLUSIVE

Where I am lagging.

Regards
M.Krish

Report message to a moderator

Re: Remote connection without Password [message #670748 is a reply to message #670746]

Tue, 24 July 2018 02:56

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Can you show us what you're doing?

Report message to a moderator

Re: Remote connection without Password [message #670750 is a reply to message #670746]

Tue, 24 July 2018 03:33

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

This does not look right

SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)

the values are incompatible. You probably want to set it to ALL, which is the default.

Report message to a moderator

Re: Remote connection without Password [message #670751 is a reply to message #670750]

Tue, 24 July 2018 05:40

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi Gazzag, John,

We are just doing this remotely.

conn sys@alias as sysdba
Then password

We tried with ALL also in it "SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)". But no use.

Thanks and regards
M.krish

Report message to a moderator

Re: Remote connection without Password [message #670752 is a reply to message #670751]

Tue, 24 July 2018 05:56

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

what does this mean,Quote:

We tried with ALL also in it "SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)". But no use.

And if you really do want help, you have to show what you are doing: the content of the files, the SQL*Plus session. Use copy/paste, enclosed within [code] tags.

Report message to a moderator

Re: Remote connection without Password [message #670753 is a reply to message #670746]

Tue, 24 July 2018 06:45

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQLNET.AUTHENTICATION_SERVICES is of no use for remote connections, it comes into play only with local connections.
(SYS%) Remote connections ALWAYS use password file.
(@seniors: I know it can be worked around but it is the biggest security hole that can set so I won't mention it.)

Report message to a moderator

Re: Remote connection without Password [message #670755 is a reply to message #670753]

Tue, 24 July 2018 07:19

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi,

Yes,
Here is the attachment, which shows the connection description.

Kindly check.

Regards
M.Krish

Attachment: SYS without password.jpg
(Size: 86.04KB, Downloaded 3823 times)

Report message to a moderator

Re: Remote connection without Password [message #670756 is a reply to message #670755]

Tue, 24 July 2018 08:36

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What does this image show?

Report message to a moderator

Re: Remote connection without Password [message #670765 is a reply to message #670756]

Wed, 25 July 2018 00:32

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi Michel,

It simply shows.

conn sys@<alias name> as sysdba

Regards
M.Krish

Report message to a moderator

Re: Remote connection without Password [message #670766 is a reply to message #670765]

Wed, 25 July 2018 00:36

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And?
What is the purpose to post it?

Report message to a moderator

Re: Remote connection without Password [message #670771 is a reply to message #670766]

Wed, 25 July 2018 02:52

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi Michel,

This is the reply to Mr.Gazzag's Post.

Quote:

Can you show us what you're doing?

Regards
M.Krish

Report message to a moderator

Re: Remote connection without Password [message #670775 is a reply to message #670771]

Wed, 25 July 2018 03:04

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OK, but it does not show if you use or not a password to connect, so it does not actually show what you're doing. Seeing your image we can't guess if it is a case of "it works" or one of "it does nor work".

Anyway, I gave you the explanation.

Report message to a moderator

Re: Remote connection without Password [message #671917 is a reply to message #670775]

Mon, 24 September 2018 04:56

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi Michel,

As I had mentioned earlier,
we were using this method.

"conn sys@<alias name> as sysdba".

But now we have removed the parameter of NTS in:
SQLNET.AUTHENTICATION_SERVICES=(...)

So, now a days we input the password, even while connecting directly to the server.

Regards
M.Krish

Report message to a moderator

Previous Topic:	authorization Required.
Next Topic:	Database security issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 15:22:45 CST 2025