Team Ai
Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face
1likes14kdownloads
user_mapping_dialog.doctree60 linesDownload Raw Back to .doctrees
1��S8�sphinx.addnodes��document���)��}�(�	rawsource����children�]�(�docutils.nodes��target���)��}�(h�.. _user_mapping_dialog:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��user-mapping-dialog�u�tagname�h3�line�K�parent�h�	_document�h�source��nD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\user_mapping_dialog.rst�ubh	�section���)��}�(hhh]�(h	�title���)��}�(h�`User Mapping Dialog`:index:�h]�(h�index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��User Mapping Dialog��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh	�Text����User Mapping Dialog�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh	�	paragraph���)��}�(h�TUse the *User Mapping* dialog to define a new mapping of a user to a foreign5server.�h]�(hJ�Use the �����}�(h hWh!hh"NhNubh	�emphasis���)��}�(h�*User Mapping*�h]�hJ�User Mapping�����}�(h hah!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�> dialog to define a new mapping of a user to a foreign6server.�����}�(h hWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhV)��}�(h��The *User Mapping* dialog organizes the development of a user mapping through7the following dialog tabs: *General* and *Options*. The *SQL* tab displays the8SQL code generated by dialog selections.�h]�(hJ�The �����}�(h hyh!hh"NhNubh`)��}�(h�*User Mapping*�h]�hJ�User Mapping�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�W dialog organizes the development of a user mapping through9the following dialog tabs: �����}�(h hyh!hh"NhNubh`)��}�(h�	*General*�h]�hJ�General�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ� and �����}�(h hyh!hh"NhNubh`)��}�(h�	*Options*�h]�hJ�Options�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�. The �����}�(h hyh!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�: tab displays the10SQL code generated by dialog selections.�����}�(h hyh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK11h h&h!hubh	�image���)��}�(h�h.. image:: images/user_mapping_general.png12    :alt: User Mapping dialog general tab13    :align: center14�h]�h}�(h]�h]�h]�h]�h]��alt��User Mapping dialog general tab��align��center��uri��images/user_mapping_general.png��15candidates�}��*�h�suhh�h"h#hKh h&h!hubhV)��}�(h�cUse the drop-down listbox in the *User* field in the *General* tab to identify16the connecting role:�h]�(hJ�!Use the drop-down listbox in the �����}�(h h�h!hh"NhNubh`)��}�(h�*User*�h]�hJ�User�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h h�ubhJ� field in the �����}�(h h�h!hh"NhNubh`)��}�(h�	*General*�h]�hJ�General�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h h�ubhJ�% tab to identify17the connecting role:�����}�(h h�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh	�bullet_list���)��}�(hhh]�(h	�	list_item���)��}�(h�:Select *CURRENT_USER* to use the name of the current role.�h]�hV)��}�(hjh]�(hJ�Select �����}�(h j!h!hh"NhNubh`)��}�(h�*CURRENT_USER*�h]�hJ�CURRENT_USER�����}�(h j(h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j!ubhJ�% to use the name of the current role.�����}�(h j!h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jubah}�(h]�h]�h]�h]�h]�uhjh"h#hKh jh!hubj)��}�(h�@Select *PUBLIC* if no other user-specific mapping is applicable.�h]�hV)��}�(hjHh]�(hJ�Select �����}�(h jJh!hh"NhNubh`)��}�(h�*PUBLIC*�h]�hJ�PUBLIC�����}�(h jQh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jJubhJ�1 if no other user-specific mapping is applicable.�����}�(h jJh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jFubah}�(h]�h]�h]�h]�h]�uhjh"h#hKh jh!hubj)��}�(h�HSelect a pre-defined role name to specify the name of an existing user.18�h]�hV)��}�(h�GSelect a pre-defined role name to specify the name of an existing user.�h]�hJ�GSelect a pre-defined role name to specify the name of an existing user.�����}�(h jsh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh joubah}�(h]�h]�h]�h]�h]�uhjh"h#hKh jh!hubeh}�(h]�h]�h]�h]�h]��bullet�h�uhjh"h#hKh h&h!hubhV)��}�(h�$Click the *Options* tab to continue.�h]�(hJ�19Click the �����}�(h j�h!hh"NhNubh`)��}�(h�	*Options*�h]�hJ�Options�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� tab to continue.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh�)��}�(h�i.. image::  images/user_mapping_options.png20    :alt: User Mapping dialog options tab21    :align: center22�h]�h}�(h]�h]�h]�h]�h]��alt��User Mapping dialog options tab��align��center��uri��images/user_mapping_options.png�h�}�h�j�suhh�h"h#hKh h&h!hubhV)��}�(h��Use the fields in the *Options* tab to specify connection options; the accepted23option names and values are specific to the foreign data wrapper associated with24the server specified in the user mapping. Click the *Add* button to add an25option/value pair.�h]�(hJ�Use the fields in the �����}�(h j�h!hh"NhNubh`)��}�(h�	*Options*�h]�hJ�Options�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�� tab to specify connection options; the accepted26option names and values are specific to the foreign data wrapper associated with27the server specified in the user mapping. Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�$ button to add an28option/value pair.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubj)��}�(hhh]�(j)��}�(h�.Specify the option name in the *Option* field.�h]�hV)��}�(hj�h]�(hJ�Specify the option name in the �����}�(h j�h!hh"NhNubh`)��}�(h�*Option*�h]�hJ�Option�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� field.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK$h j�ubah}�(h]�h]�h]�h]�h]�uhjh"h#hK$h j�h!hubj)��}�(h�4Provide a corresponding value in the *Value* field.29�h]�hV)��}�(h�3Provide a corresponding value in the *Value* field.�h]�(hJ�%Provide a corresponding value in the �����}�(h j!h!hh"NhNubh`)��}�(h�*Value*�h]�hJ�Value�����}�(h j)h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j!ubhJ� field.�����}�(h j!h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK%h jubah}�(h]�h]�h]�h]�h]�uhjh"h#hK%h j�h!hubeh}�(h]�h]�h]�h]�h]�j�h�uhjh"h#hK$h h&h!hubhV)��}�(h��Click *Add* to specify each additional option/value pair; to discard an option,30click the trash icon to the left of the row and confirm deletion in the *Delete31Row* popup.�h]�(hJ�Click �����}�(h jMh!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h jUh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jMubhJ�� to specify each additional option/value pair; to discard an option,32click the trash icon to the left of the row and confirm deletion in the �����}�(h jMh!hh"NhNubh`)��}�(h�*Delete33Row*�h]�hJ�34Delete35Row�����}�(h jgh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jMubhJ� popup.�����}�(h jMh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h h&h!hubhV)��}�(h� Click the *SQL* tab to continue.�h]�(hJ�36Click the �����}�(h jh!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ� tab to continue.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK+h h&h!hubhV)��}�(h��Your entries in the *User Mapping* dialog generate a SQL command (see an37example below). Use the *SQL* tab for review; revisit or switch tabs to make38any changes to the SQL command.�h]�(hJ�Your entries in the �����}�(h j�h!hh"NhNubh`)��}�(h�*User Mapping*�h]�hJ�User Mapping�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�? dialog generate a SQL command (see an39example below). Use the �����}�(h j�h!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�O tab for review; revisit or switch tabs to make40any changes to the SQL command.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK-h h&h!hubh%)��}�(hhh]�(h*)��}�(h�Example�h]�hJ�Example�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j�h!hh"h#hK2ubhV)��}�(h�iThe following is an example of the sql command generated by user selections in41the *User Mapping* dialog:�h]�(hJ�SThe following is an example of the sql command generated by user selections in42the �����}�(h j�h!hh"NhNubh`)��}�(h�*User Mapping*�h]�hJ�User Mapping�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� dialog:�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK4h j�h!hubh�)��}�(h�`.. image:: images/user_mapping_sql.png43    :alt: User Mapping dialog sql tab44    :align: center45�h]�h}�(h]�h]�h]�h]�h]��alt��User Mapping dialog sql tab��align��center��uri��images/user_mapping_sql.png�h�}�h�jsuhh�h"h#hK7h j�h!hubhV)��}�(h�yThe example shown demonstrates a user mapping for the *hdfs_server*. The user is46*CURRENT_USER* with a password *secret*.�h]�(hJ�6The example shown demonstrates a user mapping for the �����}�(h jh!hh"NhNubh`)��}�(h�
*hdfs_server*�h]�hJ�hdfs_server�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�. The user is47�����}�(h jh!hh"NhNubh`)��}�(h�*CURRENT_USER*�h]�hJ�CURRENT_USER�����}�(h j-h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ� with a password �����}�(h jh!hh"NhNubh`)��}�(h�*secret*�h]�hJ�secret�����}�(h j?h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK;h j�h!hubj)��}�(hhh]�(j)��}�(h�2Click the *Info* button (i) to access online help.�h]�hV)��}�(hj\h]�(hJ�48Click the �����}�(h j^h!hh"NhNubh`)��}�(h�*Info*�h]�hJ�Info�����}�(h jeh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j^ubhJ�" button (i) to access online help.�����}�(h j^h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK>h jZubah}�(h]�h]�h]�h]�h]�uhjh"h#hK>h jWh!hubj)��}�(h�%Click the *Save* button to save work.�h]�hV)��}�(hj�h]�(hJ�49Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Save*�h]�hJ�Save�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� button to save work.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK?h j�ubah}�(h]�h]�h]�h]�h]�uhjh"h#hK?h jWh!hubj)��}�(h�5Click the *Close* button to exit without saving work.�h]�hV)��}�(hj�h]�(hJ�50Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Close*�h]�hJ�Close�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�$ button to exit without saving work.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK@h j�ubah}�(h]�h]�h]�h]�h]�uhjh"h#hK@h jWh!hubj)��}�(h�?Click the *Reset* button to restore configuration parameters.51 52�h]�hV)��}�(h�=Click the *Reset* button to restore configuration parameters.�h]�(hJ�53Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Reset*�h]�hJ�Reset�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�, button to restore configuration parameters.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKAh j�ubah}�(h]�h]�h]�h]�h]�uhjh"h#hKAh jWh!hubeh}�(h]�h]�h]�h]�h]�j�h�uhjh"h#hK>h j�h!hubeh}�(h]��example�ah]�h]��example�ah]�h]�uhh$h h&h!hh"h#hK2ubeh}�(h]�(h�id1�eh]�h]�(�user mapping dialog��user_mapping_dialog�eh]�h]�uhh$h hh!hh"h#hK�expect_referenced_by_name�}�jhs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K�54translated�Kuuhh�current_source�N�current_line�N�settings��docutils.frontend��Values���)��}�(�output�Nh)N�	generator�N�	datestamp�N�root_prefix��/��source_link�N�55source_url�N�
toc_backlinks��entry��footnote_backlinks���
sectnum_xform���strip_comments�N�strip_elements_with_classes�N�
strip_classes�N�report_level�K�56halt_level�K�exit_status_level�K�debug�N�warning_stream�N�	traceback���input_encoding��	utf-8-sig��input_encoding_error_handler��strict��output_encoding��utf-8��output_encoding_error_handler�jD�error_encoding��cp1252��error_encoding_error_handler��backslashreplace��
language_code��en��record_dependencies�N�config�N�	id_prefix�h�auto_id_prefix��id��
dump_settings�N�dump_internals�N�dump_transforms�N�dump_pseudo_xml�N�expose_internals�N�strict_visitor�N�_disable_config�N�_source�h#�_destination�N�
_config_files�]��file_insertion_enabled���raw_enabled�K�line_length_limit�M'�pep_references�N�pep_base_url��https://peps.python.org/��pep_file_url_template��pep-%04d��rfc_references�N�rfc_base_url��&https://datatracker.ietf.org/doc/html/��	tab_width�K�trim_footnote_reference_space���syntax_highlight��long��smart_quotes���smartquotes_locales�]��character_level_inline_markup���doctitle_xform���
docinfo_xform���sectsubtitle_xform���
image_loading��link��embed_stylesheet���cloak_email_addresses���section_self_link���env�Nub�reporter�N�indirect_targets�]��substitution_defs�}��substitution_names�}��refnames�}��refids�}�h]�has�nameids�}�(jhjjj57ju�	nametypes�}�(j�j�j58�uh}�(hh&jh&jj�u�
footnote_refs�}��
citation_refs�}��
autofootnotes�]��autofootnote_refs�]��symbol_footnotes�]��symbol_footnote_refs�]��	footnotes�]��	citations�]��autofootnote_start�K�symbol_footnote_start�K�59id_counter��collections��Counter���}�jRKs��R��parse_messages�]��transform_messages�]�(h	�system_message���)��}�(hhh]�hV)��}�(hhh]�hJ�9Hyperlink target "user-mapping-dialog" is not referenced.�����}�h j�sbah}�(h]�h]�h]�h]�h]�uhhUh j�ubah}�(h]�h]�h]�h]�h]��level�K�type��INFO��source�h#�line�Kuhj�ubj�)��}�(hhh]�hV)��}�(hhh]�hJ�-Hyperlink target "index-0" is not referenced.�����}�h j�sbah}�(h]�h]�h]�h]�h]�uhhUh j�ubah}�(h]�h]�h]�h]�h]��level�K�type�j��source�h#�line�Kuhj�ube�transformer�N�include_log�]��60decoration�Nh!hub.
codekingpro/portable-devtools · Team Ai