Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

profile-oracle

Posted on 2011-04-26
11
Medium Priority
?
336 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..
0
Comment
Question by:nobleit
  • 7
  • 3
11 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35471825
Typo or not?  Scott's password is tiger not tige
0
 

Author Comment

by:nobleit
ID: 35471862
I purpose did that..to test the profile...
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35471877
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.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:nobleit
ID: 35471905
the issue is it is not allowing
it is automatically jumping out from oracle
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35471919
I'm not following.  What are you expecting to happen?

If a warning, I believe it's a different parameter.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35471942
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.
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 35471964
It does exactly what it says it does.

Below is a complete test run
drop user bob cascade;
drop profile two_wrong;
create profile two_wrong limit failed_login_attempts 2;

create user bob identified by bob;
grant create session to bob;
alter user bob profile two_wrong;

set echo on
conn bob/bob
conn bob/pete
conn bob/pete
conn bob/bob



output of run
--------------------------------------------------
SQL> conn bob/bob
Connected.

Session altered.

SQL> conn bob/pete
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn bob/pete
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bob/bob
ERROR:
ORA-28000: the account is locked

Open in new window

0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35472134
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.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35472155
>>"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.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35472195
Even in a 3GL language, you will likely get some sort of a 'not connected' message.
0
 

Author Closing Comment

by:nobleit
ID: 35472505
Got it clarified thanks...
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question