Table of Contents Previous Next



Use the CREATE USER MAPPING command to define a mapping that associates a Postgres role with a foreign server:
CREATE USER MAPPING FOR role_name SERVER server_name
[OPTIONS (option 'value' [, ...])];
Please note: the data adapter supports NOSASL and LDAP authentication. If you are creating a user mapping for a server that uses LDAP authentication, use the OPTIONS clause to provide the connection credentials (the username and password) for an existing LDAP user. If the server uses NOSASL authentication, omit the OPTIONS clause when creating the user mapping.
Use role_name to specify the role that will be associated with the foreign server.
Use server_name to specify the name of the server that defines a connection to the Hadoop cluster.
Use the OPTIONS clause to specify connection information for the foreign server. If you are using LDAP authentication, provide a:
username: the name of the user on the LDAP server.
password: the password associated with the username.
The following command creates a user mapping for a role named enterprisedb; the mapping is associated with a server named hdfs_server:
The command creates a user mapping for a role named enterprisedb that is associated with a server named hdfs_server. When connecting to the LDAP server, the Hive or Spark server will authenticate as alice, and provide a password of 1safepwd.
For detailed information about the CREATE USER MAPPING command, see:


Table of Contents Previous Next