A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.

pg_user_mapping

The system catalog table pg_user_mapping stores the mappings from local user to remote user. You must have administrator privileges to view this catalog. Access to this catalog is restricted from normal users, use the pg_user_mappings view instead.

Table 1. pg_catalog.pg_user_mapping
column	type	references	description
`umuser`	oid	pg_authid.oid	OID of the local role being mapped, 0 if the user mapping is public.
`umserver`	oid	pg_foreign_server.oid	OID of the foreign server that contains this mapping.
`umoptions`	text[]		User mapping-specific options, as "keyword=value" strings.