|
|
|
|
|||||||
| Forums | Portal | Register | Rules & FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Simple Scripting Problem | felixwhoals | Shell Programming and Scripting | 3 | 12-16-2007 09:24 AM |
| Simple Array in Ksh Scripting | ravikirankethe | UNIX for Dummies Questions & Answers | 2 | 11-01-2006 07:35 AM |
| simple scripting question | gennaro | Shell Programming and Scripting | 3 | 06-16-2005 11:49 PM |
| Help with simple scripting actions | Nads | Shell Programming and Scripting | 5 | 04-28-2005 08:42 PM |
| any tutorials on simple scripting? | xyyz | UNIX for Dummies Questions & Answers | 3 | 03-13-2003 09:31 AM |
 |
|
|
LinkBack | Thread Tools | Display Modes |
09-14-2006
|
|||
|
|||
|
HELP me PLS... Simple Scripting!
this is my script....
SQL> select * from dba_profiles 2 where resource_name in ('FAILED_LOGIN_ATTEMPTS','PASSWORD_LOCK_TIME') 3 order by profile; and this is the output... PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 3 DEFAULT PASSWORD_LOCK_TIME PASSWORD 5 MGR_ACCOUNT FAILED_LOGIN_ATTEMPTS PASSWORD DEFAULT PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- MGR_ACCOUNT PASSWORD_LOCK_TIME PASSWORD DEFAULT MY QUESTION is HOW CAN I DO A script that would Check IF FAILED_LOGIN_ATTEMPTS is equal to 3... PLEASE HELP ME... please talk me like im a moron.. i'm not familiar with this... thnx in advance.... 
|
| Forum Sponsor | ||
|
|
|
09-14-2006
|
|||
|
|||
|
i think you should do the check inside your SQL statement instead..like where FAILED_LOGIN_ATTEMPTS = 3 or something...just a suggestion..
|
|
09-14-2006
|
||||
|
||||
|
Can you just tell us what exactly you want to do.What i understood is you want to check for "profile" if "resource_name" is 'FAILED_LOGIN_ATTEMPTS'
and "limit" is 3. like: is that what you want? Code:
PROFILE RESOURCE_NAME RESOURCE LIMIT ------------------------------------------------------------- ABC FAILED_LOGIN_ATTEMPTS PASSWORD 3 Code:
select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS' and limit='3' order by profile
|
||||
| Google UNIX.COM |
Linear Mode
