Home » RDBMS Server » Server Administration » HOW TO HAVE ONLY ONE LOGIN ATTEMPT while connecting to Oracle
HOW TO HAVE ONLY ONE LOGIN ATTEMPT while connecting to Oracle [message #50843] Wed, 10 April 2002 20:19 Go to next message
Kumar
Messages: 115
Registered: December 1998
Senior Member
has anybody got any idea about what ORACLE VARIABLE & in which ORACLE CONFIGURATION FILE it should be set so as to Have ONLY ONE LOGIN ATTEMPT WHILE CONNECTING TO ORACLE DATABASE , BY DEFUALT IT IS 3 ATTEMPTS.

THANKS
KUMAR

Report message to a moderator

Re: HOW TO HAVE ONLY ONE LOGIN ATTEMPT while connecting to Oracle [message #50844 is a reply to message #50843] Wed, 10 April 2002 21:22 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
Configure in profile. If you don't create any profile then configure on default profile as below

ALTER PROFILE default LIMIT sessions_per_user 1;

You can check in this table for any alter DBA_PROFILES. Hope this is helping

Report message to a moderator

Previous Topic: SCN NUMBER & Chained Rows
Next Topic: Constraint Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 10:19:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.