UNIX for Dummies Questions & Answers

hi all,
i was given by my supervisor a task to search for scripts which contain oracle sqlplus i.e "myusername/mypasswd @myDB" in every /home/userfolder, which are, all the scripts made by different user. I've done some find command to search string for sqlplus, but it may up too long to respond. And it was searching, some directories denied the permission to read the files. May be it was the admin folder(right?i new to UNIX). therefore, i try to search some example in this forum but, unlucky to find one similarly. I need help to clear me up:

1) i log on as normal user only, so, it is possible to editing scripts like i mention above? what about that sort of "permission"?should asking for super user id or not?

2) how am i going to seek for oracle sqlplus scripts which have the "myusername/mypasswd @myDB" in every sh scripts,perl etc in every user directories. And if it found it, it is enable to modified?

3) is there any example/testing sed scripts which i seem maybe would help for
the task?

thanks in advance,

regards,
helmi

use find with xargs
find . -name '*.*' -print | xargs grep -il 'searchpattern'

if enough permission is not available then use the following form

find . -name '*.*' -print 2>/dev/null | xargs grep -il 'searchpattern'

write permission should be available to edit the scripts
root permission is not required as such, it is enough if you have the perms of the owner or write perm to the group atleast


Sorry am not clear with this !

for "search pattern" you can use:

grep -i "sqlplus.*\@"

This will find all occurrences of sqlplus, followed by any number of characters, followed by the @ sign. The backslash "\" escapes the @ sign so as not to be interpreted by the shell.

i think most unix operating systems support the following

find . -type f -exec grep -l sqlplus.*\@ {} \;

find from the current directory down, all files - execute the command 'grep -l sqlplus.*\@' on each of the files

grep -l sqlplus.*\@ displays each file name that contains sqlplus followed by any character up to the '@' sign

Thanks for the replies.
matrixmadhan , supposed that, i found all the script using what you guys have told me, if there any help on how to edit the pattern that i found and apply it all to scripts e.g:

Code:

find . -name '*.*' -print | xargs grep -il 'searchpattern' | sed 's/oldsearchpattern/newsearchpattern/g' (i don't know if this is the correct term of using sed!)

to make it clear:

Code:

in /home/user/

a.sh
b.sh
c.sh

i found above 3 shell script contained the "user/passwd @DB", then
is there any example shell script/sed scripts that could alter or modified all three scripts where i just input the new "user/passwd @DB" when i running the example script.

sorry for much of request,

Regards,
Helmi

you could do something like the following...

Code:

#!/bin/ksh
for file in $(find . -type f -exec grep -l sqlplus.*\@ {} \;); do
        echo ${file}
        sed -e 's%sqlplus user/pword@sid%sqlplus newuser/newpword@newsid%g' < ${file} > ${file}.$$
        mv ${file}.$$ ${file}
done

replace user, pword, sid with the current
replace newuser, newpword,newsid with replacement


run from parent directory, you should back up everything first

thanks all!
i try to think that if the script to edit the sqlplus is running, it will also edit the all the variables that set in that editing scripts. Hence, if being executed for the second time, nothing will changed, right?

using:

Code:

find . -type f -exec grep -l sqlplus.*\@ {} \;

will result:

Code:

./sql
./editor.sh

where editor.sh contained those variable of sqlplus. how to avoid this editor.sh also being edited? But, anyway, it is okay since i have to run this jus t once. Thanks again

Regards,
Helmi