Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

create_user_mapping(7) [centos man page]

CREATE USER 
MAPPING(7) PostgreSQL 9.2.7 Documentation CREATE USER MAPPING(7) NAME
CREATE_USER_MAPPING - define a new mapping of a user to a foreign server SYNOPSIS
CREATE USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC } SERVER server_name [ OPTIONS ( option 'value' [ , ... ] ) ] DESCRIPTION
CREATE USER MAPPING defines a mapping of a user to a foreign server. A user mapping typically encapsulates connection information that a foreign-data wrapper uses together with the information encapsulated by a foreign server to access an external data resource. The owner of a foreign server can create user mappings for that server for any user. Also, a user can create a user mapping for his own user name if USAGE privilege on the server has been granted to the user. PARAMETERS
user_name The name of an existing user that is mapped to foreign server. CURRENT_USER and USER match the name of the current user. When PUBLIC is specified, a so-called public mapping is created that is used when no user-specific mapping is applicable. server_name The name of an existing server for which the user mapping is to be created. OPTIONS ( option 'value' [, ... ] ) This clause specifies the options of the user mapping. The options typically define the actual user name and password of the mapping. Option names must be unique. The allowed option names and values are specific to the server's foreign-data wrapper. EXAMPLES
Create a user mapping for user bob, server foo: CREATE USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'secret'); COMPATIBILITY
CREATE USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED). SEE ALSO
ALTER USER MAPPING (ALTER_USER_MAPPING(7)), DROP USER MAPPING (DROP_USER_MAPPING(7)), CREATE FOREIGN DATA WRAPPER (CREATE_FOREIGN_DATA_WRAPPER(7)), CREATE SERVER (CREATE_SERVER(7)) PostgreSQL 9.2.7 2014-02-17 CREATE USER MAPPING(7)

Check Out this Related Man Page

ALTER 
SERVER(7) PostgreSQL 9.2.7 Documentation ALTER SERVER(7) NAME
ALTER_SERVER - change the definition of a foreign server SYNOPSIS
ALTER SERVER name [ VERSION 'new_version' ] [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ] ALTER SERVER name OWNER TO new_owner ALTER SERVER name RENAME TO new_name DESCRIPTION
ALTER SERVER changes the definition of a foreign server. The first form changes the server version string or the generic options of the server (at least one clause is required). The second form changes the owner of the server. To alter the server you must be the owner of the server. Additionally to alter the owner, you must own the server and also be a direct or indirect member of the new owning role, and you must have USAGE privilege on the server's foreign-data wrapper. (Note that superusers satisfy all these criteria automatically.) PARAMETERS
name The name of an existing server. new_version New server version. OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) Change options for the server. ADD, SET, and DROP specify the action to be performed. ADD is assumed if no operation is explicitly specified. Option names must be unique; names and values are also validated using the server's foreign-data wrapper library. new_owner The user name of the new owner of the foreign server. new_name The new name for the foreign server. EXAMPLES
Alter server foo, add connection options: ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb'); Alter server foo, change version, change host option: ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz'); COMPATIBILITY
ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The OWNER TO and RENAME forms are PostgreSQL extensions. SEE ALSO
CREATE SERVER (CREATE_SERVER(7)), DROP SERVER (DROP_SERVER(7)) PostgreSQL 9.2.7 2014-02-17 ALTER SERVER(7)
Man Page