09-04-2009
If that is for executing commands as different user, then check / search for 's' bit, that should do what you are looking for.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Any link or example to write shell script for the Connecting Oracle for Quering through SQL
thanks in advance ...
Cheers !!
Mehul Doshi (3 Replies)
Discussion started by: mehuldoshi
3 Replies
2. Shell Programming and Scripting
Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly.
It was working properly earlier, no clue why i am getting this.
Please find the log below:
FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008
Program ended. Wed Apr 30... (1 Reply)
Discussion started by: nehak
1 Replies
3. Shell Programming and Scripting
Hi All,
I was able to connect to sybase in shell script and also able to run few sql queries, something like this,
#!/usr/bin/ksh -x
temp=`echo "select name from sysobjects where type = 'U'"`
results=`isql -SDS_SERVER-UAdhocUser -Pha12 <<EOF
set rowcount 6
$temp
go
EOF`
line_count=0... (1 Reply)
Discussion started by: arvindcgi
1 Replies
4. Shell Programming and Scripting
hi,
I am trying to automate the compilation of procedures stored in .sql files in Unix. Is there any way in which we can sho err if there errors are raised in the compilation?
I am using the following code to connect to the sqlplus
sqlplus ${SQL_USER}/${SQL_PASSWORD} (5 Replies)
Discussion started by: silas.john
5 Replies
5. Shell Programming and Scripting
Hi All,
I am using below shell script using SQL*Plus to query the MAX(SEQUENCE#) from both databases V$LOG_HISTORY view.If the STANDBY appears to be falling behind by - 2, then alert mail should be sent...
How could I achieve it with improving the below script.
#!/usr/bin/ksh
... (0 Replies)
Discussion started by: a1_win
0 Replies
6. Shell Programming and Scripting
Hi all,
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
Discussion started by: satyakiran
8 Replies
7. Shell Programming and Scripting
Hi, I have problems with running shell script connecting to Oracle from the crontab. Here is the script:
#!/sbin/sh
ORACLE_HOME=/opt/oracle/10g/
export ORACLE_HOME
if
then
echo "Source path is not specified"
exit
fi
/opt/oracle/10g/bin/sqlplus user/pass@testdb << EOF
truncate table... (6 Replies)
Discussion started by: apenkov
6 Replies
8. Shell Programming and Scripting
Hi ,
I have three linux servers. I want to login from one server and check some status in the other server.
How to connect other server from one server using shell script.
Can anyone advice on this?
Thanks,
Chelladurai. (4 Replies)
Discussion started by: ckchelladurai
4 Replies
9. UNIX for Dummies Questions & Answers
Hi All,
In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally.
This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a... (1 Reply)
Discussion started by: daveu7
1 Replies
10. Shell Programming and Scripting
Shell script for connecting multiple servers and then copying 30 days old files from those server .
HI ,
I have 6 multiple servers
pla1,pla2,pla3,pla4,pla5,pla6
1. These six servers have common shared mount point /var/share
2. Running script from /var/share to connect these servers.I... (1 Reply)
Discussion started by: rcroyal88
1 Replies
LEARN ABOUT DEBIAN
eurephiadm-users
eurephiadm users(7) eurephiadm users(7)
NAME
eurephiadm-users - User management module
SYNOPSIS
eurephiadm users --list|-l [-S|--sort <sort keys>]
eurephiadm users --show|-s [-i|--uid <user id>] [-u|--username <user name>] [-l|-|-lastlog] [-L|--lastlog-details] [-a|--attempts]
[-b|--blacklist]
eurephiadm users --activate|-a [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users --deactivate|-d [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users --add|-A [-u|--username <user name>] [-P|--password <plain text password>] [-C|--certid <certificate ID>] [-D|--digest
<certificate SHA1 digest>] [-c|--certfile <certificate file>] [-2|--pkcs12]
eurephiadm users --delete|-D [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users --password|-p [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users [-h|--help [<mode>]]
DESCRIPTION
eurephiadm users manages eurephia user accounts. It provides an interface for listing, creating new, modify and delete user accounts.
MODES
Available modes:
-l | --list
[-S|--sort <sort keys>]
List all user accounts. Providing -S|--sort and a sort key will define the sort order of the list. Valid sort keys are:
uid - user ID
username - User name belonging to the user account
activated - When the user account was activated
deactivated - When the user account was deactivated
lastaccess - When the user account was last used
-s | --show
[-i|--uid <user id>] [-u|--username <user name>] [-l|--lastlog] [-L|--lastlog-details] [-a|--attempts] [-b|--blacklist]
Show user account details. --uid or --username are required. The other arguments only defined which kind of information to show.
-a | --activate
[-i|--uid <user id>] [-u|--username <user name>]
Activate a user account. --uid or --username is required.
-d | --deactivate
[-i|--uid <user id>] [-u|--username <user name>]
Deactivate a user account. --uid or --username is required.
-A | --add
[-u|--username <user name>] [-P|--password <plain text password>] [-C|--certid <certificate ID>] [-D|--digest <certificate SHA1
digest>] [-c|--certfile <certificate file>] [-2|--pkcs12]
Add a new user account. --username is required. If you want to assign a password for the new user account via the command line,
provide the password with --password.
To associate this user account against an already regstistered certificate, it can be done by either refering to the certificate ID
in eurephia using --certid or providing the certificate SHA1 digest/fingerprint to --digest.
A brand new certificate can be registered and linked to the user account directly if you have access to the certificate file. The
file can be in either PEM/DER format or PKCS#12. Use --certfile to indicate the certificate file to extract the information from
and --pkcs12 if it is a PKCS#12 file.
-D | --delete
[-i|--uid <user id>] [-u|--username <user name>]
Delete a user account. --uid or --username is required.
-p | --password
[-i|--uid <user id>] [-u|--username <user name>]
Change password on a user account. --uid or --username is required.
-h | --help
[<mode>]
Show a help screen. Without any arguments, all modes are listed. Providing a mode will show more information about the chosen
mode.
SEE ALSO
eurephiadm(7), eurephiadm-certs(7)
AUTHOR
Copyright (C) 2008-2010 David Sommerseth <dazo@users.sourceforge.net>
David Sommerseth July 2010 eurephiadm users(7)