1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
# TDS Foreign data wrapper
* **Author:** Geoff Montee
* **Name:** tds_fdw
* **File:** tds_fdw/UserMappingCreation.md
## Creating a User Mapping
### Options
User mapping parameters accepted:
* *username*
Required: Yes
The username of the account on the foreign server.
**IMPORTANT:** If you are using Azure SQL, then your username for the foreign server will be need to be in the format `username@servername`. If you only use the username, the authentication will fail.
* *password*
Required: Yes
The password of the account on the foreign server.
### Example
```SQL
CREATE USER MAPPING FOR postgres
SERVER mssql_svr
OPTIONS (username 'sa', password '');
```
|
