codekingpro/portable-devtools
114k
1
2
3<!DOCTYPE html>
4
5<html lang="en" data-content_root="./">
6 <head>
7 <meta charset="utf-8" />
8 <meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
9
10 <title>User Mapping Dialog — pgAdmin 4 8.6 documentation</title>
11 <link rel="stylesheet" type="text/css" href="_static/pygments.css?v=fa44fd50" />
12 <link rel="stylesheet" type="text/css" href="_static/style.css?v=d36593c3" />
13
14 <script src="_static/documentation_options.js?v=d4c83366"></script>
15 <script src="_static/doctools.js?v=9a2dae69"></script>
16 <script src="_static/sphinx_highlight.js?v=dc90522c"></script>
17
18 <script src="_static/sidebar.js"></script>
19
20 <link rel="index" title="Index" href="genindex.html" />
21 <link rel="search" title="Search" href="search.html" />
22 <link rel="next" title="View Dialog" href="view_dialog.html" />
23 <link rel="prev" title="Type Dialog" href="type_dialog.html" />
24 </head><body>
25 <div class="related" role="navigation" aria-label="related navigation">
26 <h3>Navigation</h3>
27 <ul>
28 <li class="right" style="margin-right: 10px">
29 <a href="genindex.html" title="General Index"
30 accesskey="I">index</a></li>
31 <li class="right" >
32 <a href="view_dialog.html" title="View Dialog"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="type_dialog.html" title="Type Dialog"
36 accesskey="P">previous</a> |</li>
37 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
38 <li class="nav-item nav-item-1"><a href="managing_database_objects.html" accesskey="U">Managing Database Objects</a> »</li>
39 <li class="nav-item nav-item-this"><a href="">User Mapping Dialog</a></li>
40 </ul>
41 </div>
42
43 <div class="document">
44 <div class="documentwrapper">
45 <div class="bodywrapper">
46 <div class="body" role="main">
47
48 <section id="user-mapping-dialog">
49<span id="id1"></span><h1><span class="target" id="index-0"></span>User Mapping Dialog<a class="headerlink" href="#user-mapping-dialog" title="Link to this heading">¶</a></h1>
50<p>Use the <em>User Mapping</em> dialog to define a new mapping of a user to a foreign
51server.</p>
52<p>The <em>User Mapping</em> dialog organizes the development of a user mapping through
53the following dialog tabs: <em>General</em> and <em>Options</em>. The <em>SQL</em> tab displays the
54SQL code generated by dialog selections.</p>
55<img alt="User Mapping dialog general tab" class="align-center" src="_images/user_mapping_general.png" />
56<p>Use the drop-down listbox in the <em>User</em> field in the <em>General</em> tab to identify
57the connecting role:</p>
58<ul class="simple">
59<li><p>Select <em>CURRENT_USER</em> to use the name of the current role.</p></li>
60<li><p>Select <em>PUBLIC</em> if no other user-specific mapping is applicable.</p></li>
61<li><p>Select a pre-defined role name to specify the name of an existing user.</p></li>
62</ul>
63<p>Click the <em>Options</em> tab to continue.</p>
64<img alt="User Mapping dialog options tab" class="align-center" src="_images/user_mapping_options.png" />
65<p>Use the fields in the <em>Options</em> tab to specify connection options; the accepted
66option names and values are specific to the foreign data wrapper associated with
67the server specified in the user mapping. Click the <em>Add</em> button to add an
68option/value pair.</p>
69<ul class="simple">
70<li><p>Specify the option name in the <em>Option</em> field.</p></li>
71<li><p>Provide a corresponding value in the <em>Value</em> field.</p></li>
72</ul>
73<p>Click <em>Add</em> to specify each additional option/value pair; to discard an option,
74click the trash icon to the left of the row and confirm deletion in the <em>Delete
75Row</em> popup.</p>
76<p>Click the <em>SQL</em> tab to continue.</p>
77<p>Your entries in the <em>User Mapping</em> dialog generate a SQL command (see an
78example below). Use the <em>SQL</em> tab for review; revisit or switch tabs to make
79any changes to the SQL command.</p>
80<section id="example">
81<h2>Example<a class="headerlink" href="#example" title="Link to this heading">¶</a></h2>
82<p>The following is an example of the sql command generated by user selections in
83the <em>User Mapping</em> dialog:</p>
84<img alt="User Mapping dialog sql tab" class="align-center" src="_images/user_mapping_sql.png" />
85<p>The example shown demonstrates a user mapping for the <em>hdfs_server</em>. The user is
86<em>CURRENT_USER</em> with a password <em>secret</em>.</p>
87<ul class="simple">
88<li><p>Click the <em>Info</em> button (i) to access online help.</p></li>
89<li><p>Click the <em>Save</em> button to save work.</p></li>
90<li><p>Click the <em>Close</em> button to exit without saving work.</p></li>
91<li><p>Click the <em>Reset</em> button to restore configuration parameters.</p></li>
92</ul>
93</section>
94</section>
95
96
97 <div class="clearer"></div>
98 </div>
99 </div>
100 </div>
101 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
102 <div class="sphinxsidebarwrapper">
103 <div>
104 <h3><a href="index.html">Table of Contents</a></h3>
105 <ul>
106<li><a class="reference internal" href="#">User Mapping Dialog</a><ul>
107<li><a class="reference internal" href="#example">Example</a></li>
108</ul>
109</li>
110</ul>
111
112 </div>
113<h3><a href="index.html">Table of Contents</a></h3>
114<ul class="current">
115<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
116<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
117<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
118<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
119<li class="toctree-l1 current"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a><ul class="current">
120<li class="toctree-l2"><a class="reference internal" href="cast_dialog.html">Cast Dialog</a></li>
121<li class="toctree-l2"><a class="reference internal" href="dbms_job_scheduler.html">Using EDB Job Scheduler</a></li>
122<li class="toctree-l2"><a class="reference internal" href="collation_dialog.html">Collation Dialog</a></li>
123<li class="toctree-l2"><a class="reference internal" href="domain_dialog.html">Domain Dialog</a></li>
124<li class="toctree-l2"><a class="reference internal" href="domain_constraint_dialog.html">Domain Constraints Dialog</a></li>
125<li class="toctree-l2"><a class="reference internal" href="event_trigger_dialog.html">Event Trigger Dialog</a></li>
126<li class="toctree-l2"><a class="reference internal" href="extension_dialog.html">Extension Dialog</a></li>
127<li class="toctree-l2"><a class="reference internal" href="foreign_data_wrapper_dialog.html">Foreign Data Wrapper Dialog</a></li>
128<li class="toctree-l2"><a class="reference internal" href="foreign_server_dialog.html">Foreign Server Dialog</a></li>
129<li class="toctree-l2"><a class="reference internal" href="foreign_table_dialog.html">Foreign Table Dialog</a></li>
130<li class="toctree-l2"><a class="reference internal" href="fts_configuration_dialog.html">FTS Configuration Dialog</a></li>
131<li class="toctree-l2"><a class="reference internal" href="fts_dictionary_dialog.html">FTS Dictionary Dialog</a></li>
132<li class="toctree-l2"><a class="reference internal" href="fts_parser_dialog.html">FTS Parser Dialog</a></li>
133<li class="toctree-l2"><a class="reference internal" href="fts_template_dialog.html">FTS Template Dialog</a></li>
134<li class="toctree-l2"><a class="reference internal" href="function_dialog.html">Function Dialog</a></li>
135<li class="toctree-l2"><a class="reference internal" href="language_dialog.html">Language Dialog</a></li>
136<li class="toctree-l2"><a class="reference internal" href="materialized_view_dialog.html">Materialized View Dialog</a></li>
137<li class="toctree-l2"><a class="reference internal" href="package_dialog.html">Package Dialog</a></li>
138<li class="toctree-l2"><a class="reference internal" href="procedure_dialog.html">Procedure Dialog</a></li>
139<li class="toctree-l2"><a class="reference internal" href="publication_dialog.html">Publication Dialog</a></li>
140<li class="toctree-l2"><a class="reference internal" href="schema_dialog.html">Schema Dialog</a></li>
141<li class="toctree-l2"><a class="reference internal" href="sequence_dialog.html">Sequence Dialog</a></li>
142<li class="toctree-l2"><a class="reference internal" href="subscription_dialog.html">Subscription Dialog</a></li>
143<li class="toctree-l2"><a class="reference internal" href="synonym_dialog.html">Synonym Dialog</a></li>
144<li class="toctree-l2"><a class="reference internal" href="trigger_function_dialog.html">Trigger Function Dialog</a></li>
145<li class="toctree-l2"><a class="reference internal" href="type_dialog.html">Type Dialog</a></li>
146<li class="toctree-l2 current"><a class="current reference internal" href="#">User Mapping Dialog</a></li>
147<li class="toctree-l2"><a class="reference internal" href="view_dialog.html">View Dialog</a></li>
148</ul>
149</li>
150<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
151<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
152<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
153<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
154<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
155<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
156<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
157<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
158<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
159</ul>
160
161<search id="searchbox" style="display: none" role="search">
162 <h3 id="searchlabel">Quick search</h3>
163 <div class="searchformwrapper">
164 <form class="search" action="search.html" method="get">
165 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
166 <input type="submit" value="Go" />
167 </form>
168 </div>
169</search>
170<script>document.getElementById('searchbox').style.display = "block"</script>
171 </div>
172<div id="sidebarbutton" title="Collapse sidebar">
173<span>«</span>
174</div>
175
176 </div>
177 <div class="clearer"></div>
178 </div>
179 <div class="related" role="navigation" aria-label="related navigation">
180 <h3>Navigation</h3>
181 <ul>
182 <li class="right" style="margin-right: 10px">
183 <a href="genindex.html" title="General Index"
184 >index</a></li>
185 <li class="right" >
186 <a href="view_dialog.html" title="View Dialog"
187 >next</a> |</li>
188 <li class="right" >
189 <a href="type_dialog.html" title="Type Dialog"
190 >previous</a> |</li>
191 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
192 <li class="nav-item nav-item-1"><a href="managing_database_objects.html" >Managing Database Objects</a> »</li>
193 <li class="nav-item nav-item-this"><a href="">User Mapping Dialog</a></li>
194 </ul>
195 </div>
196 <div class="footer" role="contentinfo">
197 <div class="related" role="navigation" aria-label="related navigation">
198 <ul>
199 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
200 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
201 <li class="right" ><a href="view_dialog.html" title="View Dialog" accesskey="N">next</a> |</li>
202 <li class="right" ><a href="type_dialog.html" title="Type Dialog" accesskey="P">previous</a> |</li>
203 </ul>
204 </div>
205 </div>
206 </body>
207</html>