05-07-2007
editing sqlplus id@passwd in multiple scripts, users and directories
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
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi evrybody!!!!
I have a problem with this shell script
INICIO=$(sqlplus -s user/user@db1 << END | awk '{printf $1}'
set head off
set feed off
select to_char(min(create_dt) , 'HH24') from table_name where trunc(create_dt)=trunc(sysdate-2);
END)
I want to recover, in INICIO, the min... (4 Replies)
Discussion started by: josecollantes
4 Replies
2. Shell Programming and Scripting
As extracting of the file /etc/passwd the ID´s that have not been used in a range specifies. (2 Replies)
Discussion started by: oscar_acm
2 Replies
3. Shell Programming and Scripting
How to execute a query which is stored in a variable.
Say for example :
v_source_query=”select count(*) from emp”
v_source_value=`sqlplus -S "$DATABASE_LOGIN" << EOF | tr '\n' ' '
set feed off
set pagesize 0
set head... (12 Replies)
Discussion started by: trupti_d
12 Replies
4. Shell Programming and Scripting
I am looking to add 3 lines in /etc/passwd via a script. Can you please give me an idea on how to write a script that can do that? (3 Replies)
Discussion started by: melanie_pfefer
3 Replies
5. Shell Programming and Scripting
This command prints out username/users in /etc/passwd:
cut -d ':' -f '1,5' /etc/passwd | sort
I wonder if I also, after above commands output, can get an output that lists number of users in the group? I need to use uniq to get rid of duplicates.
I´ve tried this, but cant get it right, can... (5 Replies)
Discussion started by: oskis
5 Replies
6. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
7. Shell Programming and Scripting
I have one parent directory and within that parent directory there are several other sub-directories and within those sub-directories there are several other "large number" of sub-directories.
All the sub directories have a shell script in them with a common file name execute_command.sh I want... (4 Replies)
Discussion started by: shoaibjameel123
4 Replies
8. Shell Programming and Scripting
I am new to shell scripting, and have not done much programming in several years. So I am very rusty at this at best. I know my way around the linux command line, but actually scripting is something I have not done too much of.
I have been tasked to come up with a script that will pull all... (5 Replies)
Discussion started by: shuiend
5 Replies
9. Solaris
Have an issue with a user or root changing the user's passwd.
We run the passwd command and a complex passwd is entered a message is displayed,
"passwd is based on a dictionary word."
We do have a dictionary file and I know for a fact the complex passwd is not in the list. This happens on a... (3 Replies)
Discussion started by: solizkewl
3 Replies
10. UNIX for Advanced & Expert Users
Hello All,
I have to restart 100's of scripts for at least 20+ users once the server restarts for any reason. I wanted to come up with a single script to trigger of all scripts/programs under all users with just one script (without root privilege).
Is it possible to do so? :confused: If not,... (6 Replies)
Discussion started by: PikK45
6 Replies
LEARN ABOUT MINIX
dh_usrlocal
DH_USRLOCAL(1) Debhelper DH_USRLOCAL(1)
NAME
dh_usrlocal - migrate usr/local directories to maintainer scripts
SYNOPSIS
dh_usrlocal [debhelperoptions] [-n]
DESCRIPTION
dh_usrlocal is a debhelper program that can be used for building packages that will provide a subdirectory in /usr/local when installed.
It finds subdirectories of usr/local in the package build directory, and removes them, replacing them with maintainer script snippets
(unless -n is used) to create the directories at install time, and remove them when the package is removed, in a manner compliant with
Debian policy. These snippets are inserted into the maintainer scripts by dh_installdeb. See dh_installdeb(1) for an explanation of
debhelper maintainer script snippets.
When the Rules-Requires-Root field is not (effectively) binary-targets, the directories in /usr/local will have ownership root:staff and
the mode will be 02775. These values have been chosen to comply with the recommendations of the Debian policy for directories in
/usr/local.
When Rules-Requires-Root has an effective value of binary-targets, the owners, groups and permissions will be preserved with one exception.
If the directory is owned by root:root, then ownership will be reset to root:staff and mode will be reset to 02775. This is useful, since
that is the group and mode policy recommends for directories in /usr/local.
OPTIONS
-n, --no-scripts
Do not modify postinst/prerm scripts.
NOTES
Note that this command is not idempotent. dh_prep(1) should be called between invocations of this command. Otherwise, it may cause multiple
instances of the same text to be added to maintainer scripts.
CONFORMS TO
Debian policy, version 2.2
SEE ALSO
debhelper(7)
This program is a part of debhelper.
AUTHOR
Andrew Stribblehill <ads@debian.org>
11.1.6ubuntu2 2018-05-10 DH_USRLOCAL(1)