Instead of calling the "ADD" function again, use continue
Some points to note... The below code is better than using cat... Also check for the users at the start...
HTH
--ahamed
Last edited by ahamed101; 12-30-2011 at 03:37 AM..
I would like to allow only one instance of a script to run at any moment.
I've tried the following solution to count the instances but the result is always the number of running instances plus one and I can't find the problem
ps -ef | grep $0 | sed '/^$/ d' | sed '/grep/ d' | wc -l
Please... (2 Replies)
Hi
i am new to aix , we are using aix 5.3 version and model is 510 and 520 model servers. in our servers contains 8 gb ram.
but servers average ram usage is reaching 99.9% , can any body help on this , is any impact if memory usage reach 99.9%.
Regards
Balaji Poola (2 Replies)
I have a processor (Solaris 5.8) with a router locally attached.
We're having trouble pinging the router interface from the processor with a normal ping command. The response from the router is "administratively prohibited", which normally indicates the access list on the router is bouncing... (1 Reply)
I am using the code below to list all the Errors files from the directory in the for loop. When the number of files are less then 6000 then it's works fine but if it more than that then for loop fails.
for file in `ls $ERR_DIR/PPL_Prov_Engine_Error_*`
do
memrecno=`cut -f2 -d'|' $file` ||... (6 Replies)
Hello, I have some 150 Cron Jobs running under my UNIX account. I want to add some more jobs. Is there a limit to the number of cron jobs that can be run on an account?
Thank you.
Pramodini (8 Replies)
Hi Guys,
Need you help in one point!
I am working on one shell script which takes following steps :
1. Taking one query result from oracle database
2. Exporting that result to Xls file
3. Mailing that file to my own mail ID
Now, I want to give a threshold limit to one of the column... (0 Replies)
Hi,
I have this problem on RHEL box. I am using two NIC's of same model and make (Intel 82557) in the adjacent PCI slots . I am using each one for different subnet and have assigned them ipaddresses and gateways of respective subnets . While one is O.K. connecting to its ... (5 Replies)
Hello All,
Let's join our hands together to appreciate Corona688 for completing and reaching to the landmark of 4000+ THANKS. I do want to appreciate Corona688 on behalf of everyone here in forum for Corona688's continuous effort of posting very useful, full of experience and knowledge posts in... (7 Replies)
#!/usr/bin/ksh
c=0
while ]; do
echo /tmp/unex NOT found, iter : $c;
((c = $c + 1));
sleep 2;
done
so, the above counter doesn't work, already tried both -lt & -gt, and changed || to &&
so what am I missing?
Thanks in advance (5 Replies)
I'm trying to create a minimal, crude keylogger for X using only a shell script. I was quickly stumped: Why do these two commands entered in a terminal emulator produce output when I type...
$ xinput test 6 | grep press
$ xinput test 6 | awk '{print $3}'
...but this command produces no... (13 Replies)
Discussion started by: DevuanFan
13 Replies
LEARN ABOUT CENTOS
alter_user_mapping
ALTER USER MAPPING(7) PostgreSQL 9.2.7 Documentation ALTER USER MAPPING(7)NAME
ALTER_USER_MAPPING - change the definition of a user mapping
SYNOPSIS
ALTER USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC }
SERVER server_name
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
DESCRIPTION
ALTER USER MAPPING changes the definition of a user mapping.
The owner of a foreign server can alter user mappings for that server for any user. Also, a user can alter a user mapping for his own user
name if USAGE privilege on the server has been granted to the user.
PARAMETERS
user_name
User name of the mapping. CURRENT_USER and USER match the name of the current user. PUBLIC is used to match all present and future
user names in the system.
server_name
Server name of the user mapping.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the user mapping. The new options override any previously specified options. ADD, SET, and DROP specify the action
to be performed. ADD is assumed if no operation is explicitly specified. Option names must be unique; options are also validated by
the server's foreign-data wrapper.
EXAMPLES
Change the password for user mapping bob, serverfoo:
ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'public');
COMPATIBILITY
ALTER USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED). There is a subtle syntax issue: The standard omits the FOR key word. Since both
CREATE USER MAPPING and DROP USER MAPPING use FOR in analogous positions, and IBM DB2 (being the other major SQL/MED implementation) also
requires it for ALTER USER MAPPING, PostgreSQL diverges from the standard here in the interest of consistency and interoperability.
SEE ALSO
CREATE USER MAPPING (CREATE_USER_MAPPING(7)), DROP USER MAPPING (DROP_USER_MAPPING(7))
PostgreSQL 9.2.7 2014-02-17 ALTER USER MAPPING(7)