Sponsored Content
Top Forums UNIX for Dummies Questions & Answers editing sqlplus id@passwd in multiple scripts, users and directories Post 302116820 by TinWalrus on Tuesday 8th of May 2007 10:02:56 PM
Old 05-08-2007
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 Smilie

Last edited by TinWalrus; 05-08-2007 at 11:50 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

sqlplus and sh scripts (to_char command))

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

Scripts for ID´s free in /etc/passwd

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

SQLplus in Shell scripts

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

append 3 users in /etc/passwd

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

Number of users in passwd

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

how to execute multiple .sql scripts from within a shell script using sqlplus

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

Find and execute shell scripts in multiple sub directories in parallel

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

Removing old user directories that are no longer Users in /etc/passwd

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

Can't change users passwd

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

Multiple Users - Multiple Scripts

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
MBR_UID_TO_UUID(3)					   BSD Library Functions Manual 					MBR_UID_TO_UUID(3)

NAME
mbr_uid_to_uuid, mbr_gid_to_uuid, mbr_uuid_to_id, mbr_sid_to_uuid, mbr_uuid_to_sid -- user and group identifier translation functions SYNOPSIS
#include <membership.h> int mbr_uid_to_uuid(uid_t id, uuid_t uu); int mbr_gid_to_uuid(gid_t id, uuid_t uu); int mbr_uuid_to_id(const uuid_t uu, uid_t *id, int *id_type); int mbr_sid_to_uuid(const nt_sid_t *sid, uuid_t uu); int mbr_uuid_to_sid(const uuid_t uu, nt_sid_t *sid); int mbr_sid_to_string(const nt_sid_t *sid, char *string); int mbr_string_to_sid(const char *string, nt_sid_t *sid); DESCRIPTION
Users and groups can be referred to in multiple ways. In addition to the traditional uid and gid, every user or group can be referenced by a 128 bit uuid. Additionally, if the user or group is hosted on a PDC or Active Directory server, it will have a 128 bit or larger sid. These routines communicate with opendirectoryd(8). mbr_uid_to_uuid() takes a uid and looks up the associated user account. It provides the the uuid for that user as an output parameter. Note that this routine will succeed and return a fabricated uuid if the input user uid does not exist. getpwuid() should be used to test for the existence of a uid. mbr_gid_to_uuid() similarly gets the uuid associated with a group. Note that this routine will succeed and return a fabricated uuid if the input group gid does not exist. getgrgid() should be used to test for the existence of a gid. mbr_uuid_to_id() takes a uuid that refers to a user or group and fetches the corresponding uid or gid. id_type is set to ID_TYPE_UID or ID_TYPE_GID to indicate which type was found. Note that mbr_uuid_to_id() always returns an id even if the uuid is not found. This returned id is not persistent, but can be used to map back to the uuid during runtime. To determine if the uuid exists, the returned id can be used in a call to getpwuid(3) or getgrgid(3). mbr_sid_to_uuid() takes a sid and returns the associated uuid. mbr_uuid_to_sid() returns a sid for the associated uuid. Two additional utility functions are available to convert between sids and a string representation. String representations may be required, for example, when text files or XML files are used to save sid values. mbr_sid_to_string() converts a sid into a string representation. The string parameter must be a buffer of at least 194 characters. The con- verted string is terminated with a nul character. mbr_string_to_sid() converts an external string representation into a sid. RETURN VALUES
These functions return 0 on success or one of the following error codes on failure: [EIO] Communication with opendirectoryd(8) failed. [ENOENT] The mapping can not be performed. [EAUTH] Communication with opendirectoryd(8) failed due to an authentication error. [EINVAL] Invalid arguments were provided. [ENOMEM] Insufficient storage space is available. mbr_gid_to_uuid() and mbr_uid_to_uuid() return 0 (success), even if the user/group does not exist. SEE ALSO
getpwuid(3), getgrgid(3), mbr_check_membership(3), opendirectoryd(8) Mac OS X October 10, 2011 Mac OS X
All times are GMT -4. The time now is 09:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy