We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

profile-oracle

nobleit
nobleit asked
on
Medium Priority
361 Views
Last Modified: 2012-05-11
I created a profile
create profile two_wrong limit failed_login_attempts 2;
alter user scott profile two_wrong;

SQL> conn scott/tige
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.

My concern is why it is automatically log out to oracle instead showing errors on two times
based on the profile created..
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Typo or not?  Scott's password is tiger not tige

Author

Commented:
I purpose did that..to test the profile...
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Ok, what did you expect to happen?

You limit to two failed logins.  After two failed, the account should become locked.

Try a failed one more time then try the right password.

Author

Commented:
the issue is it is not allowing
it is automatically jumping out from oracle
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
I'm not following.  What are you expecting to happen?

If a warning, I believe it's a different parameter.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
The docs.  Always start with the docs:

http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_6010.htm#sthref4886

FAILED_LOGIN_ATTEMPTS  Specify the number of failed attempts to log in to the user account before the account is locked. If you omit this clause, then the default is 10 times.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Top Expert 2011

Commented:
hi nobleit,
- from memory i've read somehwere that if a login attempt in sqlplus fails while you have successful connected as another user, it will take you out of Oracle for security reason in 1st attempt. that is why the message appear: "Warning: You are no longer connected to ORACLE." however you are still in Sqlplus environment to attempt the login up to the failed_login_attempts settings before the user being locked.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
>>"Warning: You are no longer connected to ORACLE."

Is that what you meant? The above post is correct.  That is just a sqlplus message telling you you are no longer logged in to a database.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Even in a 3GL language, you will likely get some sort of a 'not connected' message.

Author

Commented:
Got it clarified thanks...
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.