|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | 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 and shell scripting languages 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 01:24 PM |
| Simple Array in Ksh Scripting | ravikirankethe | UNIX for Dummies Questions & Answers | 2 | 11-01-2006 11:35 AM |
| simple scripting question | gennaro | Shell Programming and Scripting | 3 | 06-17-2005 03:49 AM |
| Help with simple scripting actions | Nads | Shell Programming and Scripting | 5 | 04-29-2005 12:42 AM |
| any tutorials on simple scripting? | xyyz | UNIX for Dummies Questions & Answers | 3 | 03-13-2003 01:31 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | 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.... |
|
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 |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
