alter_user_mapping man page on Debian

Man page or keyword search:  
man Server   8174 pages
apropos Keyword Search (all sections)
Output format
Debian logo
[printable version]

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 validated 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 posi‐
       tions, and IBM DB2 (being the other major SQL/MED implementation)  also
       requires	 it for ALTER USER MAPPING, PostgreSQL diverges from the stan‐
       dard 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	  2013-04-02		 ALTER USER MAPPING(7)
[top]

List of man pages available for Debian

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net