Permalink
Branch: master
Find file Copy path
34d8041 Jun 7, 2015
1 contributor

Users who have contributed to this file

31 lines (19 sloc) 495 Bytes

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.

  • password

Required: Yes

The password of the account on the foreign server.

Example

CREATE USER MAPPING FOR postgres
	SERVER mssql_svr 
	OPTIONS (username 'sa', password '');