ALTER USER MAPPING(7) SQL Commands ALTER USER MAPPING(7)NAME
ALTER USER MAPPING - change the definition of a user mapping
SYNOPSIS
ALTER USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC }
SERVER servername
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
username
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.
servername
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 vali-
dated by the server's foreign-data wrapper.
EXAMPLES
Change the password for user mapping bob, server foo:
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)]
SQL - Language Statements 2010-05-14 ALTER USER MAPPING(7)
Check Out this Related Man Page
DROP USER MAPPING(7) PostgreSQL 9.2.7 Documentation DROP USER MAPPING(7)NAME
DROP_USER_MAPPING - remove a user mapping for a foreign server
SYNOPSIS
DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_USER | PUBLIC } SERVER server_name
DESCRIPTION
DROP USER MAPPING removes an existing user mapping from foreign server.
The owner of a foreign server can drop user mappings for that server for any user. Also, a user can drop a user mapping for his own user
name if USAGE privilege on the server has been granted to the user.
PARAMETERS
IF EXISTS
Do not throw an error if the user mapping does not exist. A notice is issued in this case.
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.
EXAMPLES
Drop a user mapping bob, server foo if it exists:
DROP USER MAPPING IF EXISTS FOR bob SERVER foo;
COMPATIBILITY
DROP USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension.
SEE ALSO
CREATE USER MAPPING (CREATE_USER_MAPPING(7)), ALTER USER MAPPING (ALTER_USER_MAPPING(7))
PostgreSQL 9.2.7 2014-02-17 DROP USER MAPPING(7)
DOES ROOT USER HAS A PROFILE?
JUST LIKE .PROFILE FOR EVERY USER?
i UNDERSTAND AS A SECURITY REASON THAT IS GENERALLY NOT AVAILABLE?
DOES ANYBODY KNOW HOW IT IS A SECURITY THREAT?
IF WE DONT HAVE A .PROFILE FILE, THEN WHENVER WE EXPORT A VARIABLE OR DO SIMILAR STUFF, IN WHICH FILE IS THAT... (2 Replies)
Hi guys,
I am facing issues while triggering sqlplus with "/" option
I can connect to database with USER ID and password. but, if i just specify "/" option since it is "externally identiifed user" it doesn't work
Any suggestions?
mail me @ Removed.
Regards, Giri (2 Replies)
Hi all ,
Can u please help me in this. I tried to just login server through the below script
SERVER="Server_NAME"
USER="i am user"
PASSWD="mypassword"
ftp -in $SERVER<<EOF
user $USER $PASSWD
mkdir Chanakya #To create directory with my name in $HOME
ls > list
put list
bye... (5 Replies)
Hi,
I need to check that if user is not oracle the the script should exit out .
But the below script always exits evenif I am logged as oracle.
Plz help me...........
USER=`id`
echo $USER
if ; then
echo " You are logged as `id` , it must be oracle "
exit 2
fi
Regards (2 Replies)
I need to add to a BASH script if ${USER} is not in a list of users (smitha, brownd, adamsp) then do something... what is the best shortest way to accomplish an if statement with a list like this? Also the list of users should be in the script, not an external file.
Thanks! (5 Replies)
This is the way
sed -i 's/home/$USER/.config/hello_there//g' /home/$USER/.gnomerc
But, as far as I saw you cannot add any "/" in the string you want to remove....
So, what should I do in order to remove this path (which contains "/") ?:confused: (7 Replies)
I need some variable help
TEMP1=Jane
TEMP2=Sue
X=1
eval USER=TEMP${X}
echo $USER
This gives output USER1
I would like to get Jane
I have tried
eval USER='TEMP${X}'
eval USER="TEMP${X}"
eval USER=`TEMP${X}` (3 Replies)
i have a script like this:
cat moveusers | while read USER
do
rsync -av /home/s12/$USER /home/$USER
done
but it's skipping all of the files in /$USER/mail
why is rsync not acting "recursively" here?
sent 4658 bytes received 20 bytes 9356.00 bytes/sec
total size is 16785237 speedup... (3 Replies)
#!/bin/sh
for ip in $(cat /root/Desktop/ftp.txt)
do
HOST=$ip
USER='bob'
PASS='bob'
ftp -n $HOST <<EOF
user bob bob
EOF
echo "$ip"
done
the Above code i want to use check and verify login works on multiple ftp servers on my network. However the ftp servers are dynamic in setup... (5 Replies)
I have a below command
ALTER TABLE `abc` ADD PARTITION ( PARTITION 20130613 VALUES less than (DAY('13')));
Below is requirement
It runs in Loop
as DAY start with 13 and end with 100 along with this of counter "20130613" also increases per command
as the next command should be
... (8 Replies)
I need to split a file based on headers found
Input file
file1 content:
ADD
john
mickey
DROP
matt
sam
output of file F1
john
mickey
output of file F2
matt
sam (5 Replies)
Hi Team,
Here's the record in a file.
abc\USER DEFINED\123\345\adf\aq1
Delimiter here is "\USER DEFINED\"
Expected output:
abc|123\345\adf\aq1
Find "\USER DEFINED\" and replace it with "|".
Can anyone please help us to fix this issue?
Please use CODE tags as required by... (5 Replies)
I need to be able to say "My name is $USER' when I use echo it work, when I use printf it print more 'my last name@.........'. How can I get just the part before the @ sign. I have to use printf. using UNIX.
------ Post updated at 01:17 PM ------
I used the activation code but I still... (2 Replies)