IMHO you should open 1 thread for each question, else people who are seeing this thread in future could be confused. So I am answering very first question of yours. Could you please try following.
Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
Hi
I am looking for the script which can move 1month old data from a TXT file.actully in this file data is appended on daily basis.pleasehalp me out.
Thanks in advance (3 Replies)
I have a code given below...
ERROR=`grep "Job Status" ${LOG_FILE}`
ERROR=${ERROR##*\(}
ERROR=${ERROR%%\)*}
if
then
echo "The job completed successfully"
EXIT_STATUS=0
else
echo "The job failed"
EXIT_STATUS=1
fi
can anybody tell me what is
ERROR=${ERROR##*\(}... (1 Reply)
hi
i am new to linux world please help me,i have two files in diff location
i need to compare both and i need to see difference b/w them
ex /media/txt (file1)
xxxxxx
xxxxxx
xxxxx
xxxxxx
xxxxxx
/media/rev/ (file2) rev is a folder which contains some files so i need to compare the files in... (3 Replies)
Hi!! Im new to shell scripting. I have an important assignment to complete in my company tomorrow. Please help me. I have to write an interactive script which does the following thing:
There is a file named ""rules"in a folder say /home/f1/ . This file contains text in the form:
123
345... (5 Replies)
hi,
Im trying to select from a sql using shell script and once i get count i need to add the count to the subject line and send mail to every1..
ex :
Select count(*) from emp;
In Shell script
echo $PASSWORD|$ORACLE_HOME/bin/sqlplus $USERID@$DBNAME @$SCRIPT_DIR/emp_count.sql... (1 Reply)
Hey all. Sometimes I'm tasked to change some router configs for the entire network (over 3,000 Cisco routers). Most of the time its a global config parameter so its done with a loop and an IP list as its the same configuration change for all routers. This is working OK.
However, sometimes an... (3 Replies)
Hi,
I am developing a script for writing out the failed jobs in file,
1)First step i need to create an empty file Status with today's date.
2)After that i need to execute the below command:
dsjob -server servername -user uname -password pwd -ljobs projectname
This will listout all... (5 Replies)
Hi,
I have a big list like this --> 3285
3289
328D
3291
3295
3299
329D
32A1
I need to make it like -->
3285|3289|328D|3291|3295|3299|329D|32A1
Please suggest. This is Linux OS. (8 Replies)
Hi team,
I am looking to execute some command through xargs.
$cat testfile | grep myloc
alias myloc='cd /export/nfs-1sv-23/'
I am trying to execute that alias as soon as i cat and grep ?
I tried with $cat testfile | grep myloc | xargs --> no luck ...
Can some one assist me with... (6 Replies)
TAG flow Between SDR and DELTA
SDR is the Source table.
Delta is the target table having one staging table and one Main table.
Tags flows between SDR and Delta through ER gateway.
From SDR (SDR.CUSTOMER_PRODUCT and SDR.CUSTOMER_PRODUCT_RELATIONSHIP) the Tags flows to ER... (2 Replies)
Discussion started by: patitapaban
2 Replies
LEARN ABOUT CENTOS
set_session_authorization
SET SESSION AUTHORIZATION(7) PostgreSQL 9.2.7 Documentation SET SESSION AUTHORIZATION(7)NAME
SET_SESSION_AUTHORIZATION - set the session user identifier and the current user identifier of the current session
SYNOPSIS
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION user_name
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION
DESCRIPTION
This command sets the session user identifier and the current user identifier of the current SQL session to be user_name. The user name can
be written as either an identifier or a string literal. Using this command, it is possible, for example, to temporarily become an
unprivileged user and later switch back to being a superuser.
The session user identifier is initially set to be the (possibly authenticated) user name provided by the client. The current user
identifier is normally equal to the session user identifier, but might change temporarily in the context of SECURITY DEFINER functions and
similar mechanisms; it can also be changed by SET ROLE (SET_ROLE(7)). The current user identifier is relevant for permission checking.
The session user identifier can be changed only if the initial session user (the authenticated user) had the superuser privilege.
Otherwise, the command is accepted only if it specifies the authenticated user name.
The SESSION and LOCAL modifiers act the same as for the regular SET(7) command.
The DEFAULT and RESET forms reset the session and current user identifiers to be the originally authenticated user name. These forms can be
executed by any user.
NOTES
SET SESSION AUTHORIZATION cannot be used within a SECURITY DEFINER function.
EXAMPLES
SELECT SESSION_USER, CURRENT_USER;
session_user | current_user
--------------+--------------
peter | peter
SET SESSION AUTHORIZATION 'paul';
SELECT SESSION_USER, CURRENT_USER;
session_user | current_user
--------------+--------------
paul | paul
COMPATIBILITY
The SQL standard allows some other expressions to appear in place of the literal user_name, but these options are not important in
practice. PostgreSQL allows identifier syntax ("username"), which SQL does not. SQL does not allow this command during a transaction;
PostgreSQL does not make this restriction because there is no reason to. The SESSION and LOCAL modifiers are a PostgreSQL extension, as is
the RESET syntax.
The privileges necessary to execute this command are left implementation-defined by the standard.
SEE ALSO
SET ROLE (SET_ROLE(7))
PostgreSQL 9.2.7 2014-02-17 SET SESSION AUTHORIZATION(7)