The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


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

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-14-2006
Registered User
 

Join Date: Sep 2006
Posts: 5
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....
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 09-14-2006
Registered User
 

Join Date: Sep 2006
Posts: 1,448
i think you should do the check inside your SQL statement instead..like where FAILED_LOGIN_ATTEMPTS = 3 or something...just a suggestion..
Reply With Quote
  #3 (permalink)  
Old 09-14-2006
Dhruva's Avatar
Registered User
 

Join Date: Mar 2006
Location: India
Posts: 241
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
then
Code:
select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS' and limit='3'
order by profile
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes




All times are GMT -7. The time now is 10:59 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0