OraFAQ Forum: Security » Authentication and passwordfile

Home » RDBMS Server » Security » Authentication and passwordfile (Oracle database 12)

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

Authentication and passwordfile [message #670769]

Wed, 25 July 2018 02:48

madem
Messages: 2
Registered: July 2018

Junior Member

Hello

I need your help to understand what is passwordfile and how does it works ?
I know it's possible to connecter "as sysdba" or "as sysoper". Tell me if i'm wrong, but each user that have sysdba or sysoper system privileges can connect by specify "as sysdba" or "as sysoper" whitout enter a password (thank's to passwordfile), is it correct ?

So, if a set remote_password_file to exclusive, each user (i'm talking about os user) can connect to the database by using "sys as sysdba" ?

I read into the CIS that remote_password_file must be set to None, i just need to understand why.
I'm not rellay sure to uinderstand well about passwordfile authentication. Tell me if i'm wrong, but it's a file where password of each user who have privilege "sysdba /sysoper" are stocked ? And we use it to authenticate to the database whitout have to enter any password ?

So if you can help me to understand about passwordfile, it will be very nice Smile

Thank's

Report message to a moderator

[Message index]

		Authentication and passwordfile By: madem on Wed, 25 July 2018 02:48
		Re: Authentication and passwordfile By: Michel Cadot on Wed, 25 July 2018 02:57
		Re: Authentication and passwordfile By: madem on Wed, 25 July 2018 03:13
		Re: Authentication and passwordfile By: Michel Cadot on Wed, 25 July 2018 03:28
		Re: Authentication and passwordfile By: EdStevens on Wed, 25 July 2018 07:25
		Re: Authentication and passwordfile By: John Watson on Wed, 25 July 2018 03:02

Previous Topic:	Securing Marketing Automation
Next Topic:	JDBC connections on TLS/2484 and TCP/1521

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:03:19 CDT 2024