Home » RDBMS Server » Server Administration » internal password
internal password [message #51838] Mon, 17 June 2002 02:58 Go to next message
Silviu
Messages: 6
Registered: April 2002
Junior Member
Hi,
How can I set password to "internal" user? I want to restrict access to database with this user from "svrmgrl".
Thank.
Silviu.

Report message to a moderator

Re: internal password [message #51843 is a reply to message #51838] Mon, 17 June 2002 07:27 Go to previous messageGo to next message
topgunroot
Messages: 3
Registered: June 2002
Junior Member
$ORACLE_HOME/bin/orapwd file=pwdfile password=oracle entries=5

Report message to a moderator

Re: internal password [message #51847 is a reply to message #51843] Mon, 17 June 2002 12:47 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
If someone cracks the system password they can change any password including SYS.

Report message to a moderator

Re: internal password [message #51850 is a reply to message #51843] Mon, 17 June 2002 21:46 Go to previous message
topgunroot
Messages: 3
Registered: June 2002
Junior Member
1. if local user belong to sysdba group (you assign it when install), can "connect internal" without passwd locally.
2.to allow remote administrative connections you must:
Set up a password file for the database on the server
and Set up any relevant init.ora parameters "REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE"
3.to disable remote administrative connections set
"REMOTE_LOGIN_PASSWORDFILE=NONE"

hope it can help.

Report message to a moderator

Previous Topic: BDE oracle8 to 9
Next Topic: Question on database instance creation?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:30:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.