Team Ai
Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face
1likes14kdownloads
role_dialog.doctree173 linesDownload Raw Back to .doctrees
1����sphinx.addnodes��document���)��}�(�	rawsource����children�]�(�docutils.nodes��target���)��}�(h�.. _role_dialog:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��role-dialog�u�tagname�h3�line�K�parent�h�	_document�h�source��fD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\role_dialog.rst�ubh	�section���)��}�(hhh]�(h	�title���)��}�(h� `Login/Group Role Dialog`:index:�h]�(h�index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��Login/Group Role Dialog��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh	�Text����Login/Group Role Dialog�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh	�	paragraph���)��}�(h��Use the *Login/Group Role* dialog to define a role. A role may be an individual5user (with or without login privileges) or a group of users. Note that roles6defined at the cluster level are shared by all databases in the cluster.�h]�(hJ�Use the �����}�(h hWh!hh"NhNubh	�emphasis���)��}�(h�*Login/Group Role*�h]�hJ�Login/Group Role�����}�(h hah!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�� dialog to define a role. A role may be an individual7user (with or without login privileges) or a group of users. Note that roles8defined at the cluster level are shared by all databases in the cluster.�����}�(h hWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhV)��}�(hXThe *Login/Group Role* dialog organizes the creation and management of roles9through the following dialog tabs: *General*, *Definition*, *Privileges*, *Memberships*10*Parameters*, and *Security*. The *SQL* tab displays the SQL code generated by11dialog selections.�h]�(hJ�The �����}�(h hyh!hh"NhNubh`)��}�(h�*Login/Group Role*�h]�hJ�Login/Group Role�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�Z dialog organizes the creation and management of roles12through the 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�, �����}�(h hyh!hh"NhNubh`)��}�(h�*Definition*�h]�hJ�13Definition�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�, �����}�h hysbh`)��}�(h�*Privileges*�h]�hJ�14Privileges�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�, �����}�h hysbh`)��}�(h�
*Memberships*�h]�hJ�Memberships�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�15�����}�(h hyh!hh"NhNubh`)��}�(h�*Parameters*�h]�hJ�16Parameters�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�, and �����}�(h hyh!hh"NhNubh`)��}�(h�17*Security*�h]�hJ�Security�����}�(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 the SQL code generated by18dialog selections.�����}�(h hyh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh	�image���)��}�(h�X.. image:: images/role_general.png19    :alt: Role dialog general tab20    :align: center21�h]�h}�(h]�h]�h]�h]�h]��alt��Role dialog general tab��align��center��uri��images/role_general.png��22candidates�}��*�j(suhjh"h#hKh h&h!hubhV)��}�(h�9Use the fields on the *General* tab to identify the role.�h]�(hJ�Use the fields on the �����}�(h j,h!hh"NhNubh`)��}�(h�	*General*�h]�hJ�General�����}�(h j4h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j,ubhJ� tab to identify the role.�����}�(h j,h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh	�bullet_list���)��}�(hhh]�(h	�	list_item���)��}�(h�eUse the *Name* field to provide the name of the role. The name will be23displayed in the tree control.�h]�hV)��}�(h�eUse the *Name* field to provide the name of the role. The name will be24displayed in the tree control.�h]�(hJ�Use the �����}�(h jWh!hh"NhNubh`)��}�(h�*Name*�h]�hJ�Name�����}�(h j_h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jWubhJ�W field to provide the name of the role. The name will be25displayed in the tree control.�����}�(h jWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jSubah}�(h]�h]�h]�h]�h]�uhjQh"h#hKh jNh!hubjR)��}�(h�7Provide a note about the role in the *Comments* field.26�h]�hV)��}�(h�6Provide a note about the role in the *Comments* field.�h]�(hJ�%Provide a note about the role in the �����}�(h j�h!hh"NhNubh`)��}�(h�27*Comments*�h]�hJ�Comments�����}�(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#hKh j}ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hKh jNh!hubeh}�(h]�h]�h]�h]�h]��bullet�j+uhjLh"h#hKh h&h!hubhV)��}�(h�'Click the *Definition* tab to continue.�h]�(hJ�28Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Definition*�h]�hJ�29Definition�����}�(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!hubj)��}�(h�^.. image:: images/role_definition.png30    :alt: Role dialog definition tab31    :align: center32�h]�h}�(h]�h]�h]�h]�h]��alt��Role dialog definition tab��align��center��uri��images/role_definition.png�j)}�j+j�suhjh"h#hKh h&h!hubhV)��}�(h�JUse the *Definition* tab to set a password and configure connection rules:�h]�(hJ�Use the �����}�(h j�h!hh"NhNubh`)��}�(h�*Definition*�h]�hJ�33Definition�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�6 tab to set a password and configure connection rules:�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK h h&h!hubjM)��}�(hhh]�(jR)��}�(h�QProvide a password that will be associated with the role in the *Password*34field.�h]�hV)��}�(h�QProvide a password that will be associated with the role in the *Password*35field.�h]�(hJ�@Provide a password that will be associated with the role in the �����}�(h jh!hh"NhNubh`)��}�(h�36*Password*�h]�hJ�Password�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�37field.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h jubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK"h j�h!hubjR)��}�(h��Provide an expiration date for the password in the *Account Expires* field38(the role does not expire).  The expiration date is not enforced when a user39logs in with a non-password-based authentication method.�h]�hV)��}�(h��Provide an expiration date for the password in the *Account Expires* field40(the role does not expire).  The expiration date is not enforced when a user41logs in with a non-password-based authentication method.�h]�(hJ�3Provide an expiration date for the password in the �����}�(h j0h!hh"NhNubh`)��}�(h�*Account Expires*�h]�hJ�Account Expires�����}�(h j8h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j0ubhJ�� field42(the role does not expire).  The expiration date is not enforced when a user43logs in with a non-password-based authentication method.�����}�(h j0h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK$h j,ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK$h j�h!hubjR)��}�(h��If the role is a login role, specify how many concurrent connections the role44can make in the *Connection Limit* field. The default value (*-1*) allows45unlimited connections.46�h]�hV)��}�(h��If the role is a login role, specify how many concurrent connections the role47can make in the *Connection Limit* field. The default value (*-1*) allows48unlimited connections.�h]�(hJ�^If the role is a login role, specify how many concurrent connections the role49can make in the �����}�(h jZh!hh"NhNubh`)��}�(h�*Connection Limit*�h]�hJ�Connection Limit�����}�(h jbh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jZubhJ� field. The default value (�����}�(h jZh!hh"NhNubh`)��}�(h�*-1*�h]�hJ�-1�����}�(h jth!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jZubhJ�) allows50unlimited connections.�����}�(h jZh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h jVubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK'h j�h!hubeh}�(h]�h]�h]�h]�h]�j�j+uhjLh"h#hK"h h&h!hubhV)��}�(h�'Click the *Privileges* tab to continue.�h]�(hJ�51Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Privileges*�h]�hJ�52Privileges�����}�(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#hK+h h&h!hubj)��}�(h�^.. image:: images/role_privileges.png53    :alt: Role dialog privileges tab54    :align: center55�h]�h}�(h]�h]�h]�h]�h]��alt��Role dialog privileges tab��align��center��uri��images/role_privileges.png�j)}�j+j�suhjh"h#hK-h h&h!hubhV)��}�(h�9Use the *Privileges* tab to grant privileges to the role.�h]�(hJ�Use the �����}�(h j�h!hh"NhNubh`)��}�(h�*Privileges*�h]�hJ�56Privileges�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�% tab to grant privileges to the role.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK1h h&h!hubjM)��}�(hhh]�(jR)��}�(h�oMove the *Can login?* switch to the *Yes* position if the role has login57privileges. The default value is *No*.�h]�hV)��}�(h�oMove the *Can login?* switch to the *Yes* position if the role has login58privileges. The default value is *No*.�h]�(hJ�	Move the �����}�(h j�h!hh"NhNubh`)��}�(h�*Can login?*�h]�hJ�59Can login?�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� switch to the �����}�(h j�h!hh"NhNubh`)��}�(h�*Yes*�h]�hJ�Yes�����}�(h j60h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�A position if the role has login61privileges. The default value is �����}�(h j�h!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h j�ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK3h j�h!hubjR)��}�(h�|Move the *Superuser* switch to the *Yes* position if the role is a superuser62within the database. The default value is *No*.�h]�hV)��}�(h�|Move the *Superuser* switch to the *Yes* position if the role is a superuser63within the database. The default value is *No*.�h]�(hJ�	Move the �����}�(h j>h!hh"NhNubh`)��}�(h�*Superuser*�h]�hJ�	Superuser�����}�(h jFh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j>ubhJ� switch to the �����}�(h j>h!hh"NhNubh`)��}�(h�*Yes*�h]�hJ�Yes�����}�(h jXh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j>ubhJ�O position if the role is a superuser64within the database. The default value is �����}�(h j>h!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h jjh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j>ubhJ�.�����}�(h j>h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j:ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK5h j�h!hubjR)��}�(h��Move the *Create roles?* switch to the *Yes* position to specify whether a65role is permitted to create roles. A role with this privilege can alter and66drop roles. The default value is *No*.�h]�hV)��}�(h��Move the *Create roles?* switch to the *Yes* position to specify whether a67role is permitted to create roles. A role with this privilege can alter and68drop roles. The default value is *No*.�h]�(hJ�	Move the �����}�(h j�h!hh"NhNubh`)��}�(h�*Create roles?*�h]�hJ�
Create roles?�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� switch to the �����}�(h j�h!hh"NhNubh`)��}�(h�*Yes*�h]�hJ�Yes�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�� position to specify whether a69role is permitted to create roles. A role with this privilege can alter and70drop roles. The default value is �����}�(h j�h!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK7h j�ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK7h j�h!hubjR)��}�(h��Move the *Create databases* switch to the *Yes* position to control whether a71role can create databases. The default value is *No*.�h]�hV)��}�(h��Move the *Create databases* switch to the *Yes* position to control whether a72role can create databases. The default value is *No*.�h]�(hJ�	Move the �����}�(h j�h!hh"NhNubh`)��}�(h�*Create databases*�h]�hJ�Create databases�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� switch to the �����}�(h j�h!hh"NhNubh`)��}�(h�*Yes*�h]�hJ�Yes�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�O position to control whether a73role can create databases. The default value is �����}�(h j�h!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK:h j�ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK:h j�h!hubjR)��}�(h��Move the *Inherit rights from the parent roles?* switch to the *No* position74if a role does not inherit privileges. The default value is *Yes*.�h]�hV)��}�(h��Move the *Inherit rights from the parent roles?* switch to the *No* position75if a role does not inherit privileges. The default value is *Yes*.�h]�(hJ�	Move the �����}�(h j(h!hh"NhNubh`)��}�(h�'*Inherit rights from the parent roles?*�h]�hJ�%Inherit rights from the parent roles?�����}�(h j0h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j(ubhJ� switch to the �����}�(h j(h!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h jBh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j(ubhJ�F position76if a role does not inherit privileges. The default value is �����}�(h j(h!hh"NhNubh`)��}�(h�*Yes*�h]�hJ�Yes�����}�(h jTh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j(ubhJ�.�����}�(h j(h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK<h j$ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK<h j�h!hubjR)��}�(h��Move the *Can initiate streaming replication and backups?* switch to the *Yes*77position to control whether a role can initiate streaming replication or put78the system in and out of backup mode. The default value is *No*.�h]�hV)��}�(h��Move the *Can initiate streaming replication and backups?* switch to the *Yes*79position to control whether a role can initiate streaming replication or put80the system in and out of backup mode. The default value is *No*.�h]�(hJ�	Move the �����}�(h jvh!hh"NhNubh`)��}�(h�1*Can initiate streaming replication and backups?*�h]�hJ�/Can initiate streaming replication and backups?�����}�(h j~h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jvubhJ� switch to the �����}�(h jvh!hh"NhNubh`)��}�(h�*Yes*�h]�hJ�Yes�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jvubhJ��81position to control whether a role can initiate streaming replication or put82the system in and out of backup mode. The default value is �����}�(h jvh!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jvubhJ�.�����}�(h jvh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK>h jrubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK>h j�h!hubjR)��}�(h��Move the *Bypass RLS?* switch to the *Yes* position to control whether a83role can bypasses every row-level security (RLS) policy. The default value is *No*.84�h]�hV)��}�(h��Move the *Bypass RLS?* switch to the *Yes* position to control whether a85role can bypasses every row-level security (RLS) policy. The default value is *No*.�h]�(hJ�	Move the �����}�(h j�h!hh"NhNubh`)��}�(h�
*Bypass RLS?*�h]�hJ�Bypass RLS?�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� switch to the �����}�(h j�h!hh"NhNubh`)��}�(h�*Yes*�h]�hJ�Yes�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�m position to control whether a86role can bypasses every row-level security (RLS) policy. The default value is �����}�(h j�h!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKAh j�ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hKAh j�h!hubeh}�(h]�h]�h]�h]�h]�j�j+uhjLh"h#hK3h h&h!hubj)��}�(h�^.. image:: images/role_membership.png87    :alt: Role dialog membership tab88    :align: center89�h]�h}�(h]�h]�h]�h]�h]��alt��Role dialog membership tab��align��center��uri��images/role_membership.png�j)}�j+j#suhjh"h#hKDh h&h!hubjM)��}�(hhh]�jR)��}�(hXOSpecify member of the role in the *Member of* field and specify the members in the *Member* field.90Confirm each selection by checking the checkbox to the right of the role name;91delete a selection by clicking the *x* to the left of the role name.92Membership conveys the privileges granted to the specified role to each of93its members.94�h]�hV)��}�(hXNSpecify member of the role in the *Member of* field and specify the members in the *Member* field.95Confirm each selection by checking the checkbox to the right of the role name;96delete a selection by clicking the *x* to the left of the role name.97Membership conveys the privileges granted to the specified role to each of98its members.�h]�(hJ�"Specify member of the role in the �����}�(h j,h!hh"NhNubh`)��}�(h�*Member of*�h]�hJ�	Member of�����}�(h j4h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j,ubhJ�& field and specify the members in the �����}�(h j,h!hh"NhNubh`)��}�(h�*Member*�h]�hJ�Member�����}�(h jFh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j,ubhJ�z field.99Confirm each selection by checking the checkbox to the right of the role name;100delete a selection by clicking the �����}�(h j,h!hh"NhNubh`)��}�(h�*x*�h]�hJ�x�����}�(h jXh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j,ubhJ�v to the left of the role name.101Membership conveys the privileges granted to the specified role to each of102its members.�����}�(h j,h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKHh j(ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hKHh j%h!hubah}�(h]�h]�h]�h]�h]�j�j+uhjLh"h#hKHh h&h!hubhV)��}�(h�'Click the *Parameters* tab to continue.�h]�(hJ�103Click the �����}�(h j|h!hh"NhNubh`)��}�(h�*Parameters*�h]�hJ�104Parameters�����}�(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#hKNh h&h!hubj)��}�(h�^.. image:: images/role_parameters.png105    :alt: Role dialog parameters tab106    :align: center107�h]�h}�(h]�h]�h]�h]�h]��alt��Role dialog parameters tab��align��center��uri��images/role_parameters.png�j)}�j+j�suhjh"h#hKPh h&h!hubhV)��}�(hXUse the fields on the *Parameters* tab to set session defaults for a selected108configuration parameter when the role is connected to a specified database. This109tab invokes the ALTER ROLE... SET configuration_parameter syntax. Click the110*Add* icon (+) to assign a value for a parameter.�h]�(hJ�Use the fields on the �����}�(h j�h!hh"NhNubh`)��}�(h�*Parameters*�h]�hJ�111Parameters�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�� tab to set session defaults for a selected112configuration parameter when the role is connected to a specified database. This113tab invokes the ALTER ROLE… SET configuration_parameter syntax. Click the114�����}�(h j�h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�, icon (+) to assign a value for a parameter.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKTh h&h!hubjM)��}�(hhh]�(jR)��}�(h�DUse the drop-down listbox in the *Name* field to select a parameter.�h]�hV)��}�(hj�h]�(hJ�!Use the drop-down listbox in the �����}�(h j�h!hh"NhNubh`)��}�(h�*Name*�h]�hJ�Name�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� field to select a parameter.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKYh j�ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hKYh j�h!hubjR)��}�(h�;Use the *Value* field to specify a value for the parameter.�h]�hV)��}�(hj
h]�(hJ�Use the �����}�(h jh!hh"NhNubh`)��}�(h�*Value*�h]�hJ�Value�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�, field to specify a value for the parameter.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKZh jubah}�(h]�h]�h]�h]�h]�uhjQh"h#hKZh j�h!hubjR)��}�(h�HUse the drop-down listbox in the *Database* field to select a database.115�h]�hV)��}�(h�GUse the drop-down listbox in the *Database* field to select a database.�h]�(hJ�!Use the drop-down listbox in the �����}�(h j8h!hh"NhNubh`)��}�(h�116*Database*�h]�hJ�Database�����}�(h j@h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j8ubhJ� field to select a database.�����}�(h j8h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK[h j4ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK[h j�h!hubeh}�(h]�h]�h]�h]�h]�j�j+uhjLh"h#hKYh h&h!hubhV)��}�(h��Click the *Add* icon (+) to specify each additional parameter; to discard a117parameter, click the trash icon to the left of the row and confirm the deletion118in the *Delete Row* popup.�h]�(hJ�119Click the �����}�(h jdh!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h jlh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jdubhJ�� icon (+) to specify each additional parameter; to discard a120parameter, click the trash icon to the left of the row and confirm the deletion121in the �����}�(h jdh!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�122Delete Row�����}�(h j~h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jdubhJ� popup.�����}�(h jdh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK]h h&h!hubhV)��}�(h�%Click the *Security* tab to continue.�h]�(hJ�123Click the �����}�(h j�h!hh"NhNubh`)��}�(h�124*Security*�h]�hJ�Security�����}�(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#hKah h&h!hubj)��}�(h�Z.. image:: images/role_security.png125    :alt: Role dialog security tab126    :align: center127�h]�h}�(h]�h]�h]�h]�h]��alt��Role dialog security tab��align��center��uri��images/role_security.png�j)}�j+j�suhjh"h#hKch h&h!hubhV)��}�(h��Use the *Security* tab to define security labels applied to the role. Click the128*Add* icon (+) to add each security label selection.�h]�(hJ�Use the �����}�(h j�h!hh"NhNubh`)��}�(h�129*Security*�h]�hJ�Security�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�> tab to define security labels applied to the role. Click the130�����}�(h j�h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�/ icon (+) to add each security label selection.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKgh h&h!hubjM)��}�(hhh]�(jR)��}�(h��Specify a security label provider in the *Provider* field. The named provider131must be loaded and must consent to the proposed labeling operation.�h]�hV)��}�(h��Specify a security label provider in the *Provider* field. The named provider132must be loaded and must consent to the proposed labeling operation.�h]�(hJ�)Specify a security label provider in the �����}�(h jh!hh"NhNubh`)��}�(h�133*Provider*�h]�hJ�Provider�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�^ field. The named provider134must be loaded and must consent to the proposed labeling operation.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKjh j�ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hKjh j�h!hubjR)��}�(hXSpecify a a security label in the *Security Label* field. The meaning of a135given label is at the discretion of the label provider. PostgreSQL places no136restrictions on whether or how a label provider must interpret security137labels; it merely provides a mechanism for storing them.138�h]�hV)��}�(hXSpecify a a security label in the *Security Label* field. The meaning of a139given label is at the discretion of the label provider. PostgreSQL places no140restrictions on whether or how a label provider must interpret security141labels; it merely provides a mechanism for storing them.�h]�(hJ�"Specify a a security label in the �����}�(h j*h!hh"NhNubh`)��}�(h�*Security Label*�h]�hJ�Security Label�����}�(h j2h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j*ubhJ�� field. The meaning of a142given label is at the discretion of the label provider. PostgreSQL places no143restrictions on whether or how a label provider must interpret security144labels; it merely provides a mechanism for storing them.�����}�(h j*h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKlh j&ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hKlh j�h!hubeh}�(h]�h]�h]�h]�h]�j�j+uhjLh"h#hKjh h&h!hubhV)��}�(h�|To discard a security label, click the trash icon to the left of the row and145confirm the deletion in the *Delete Row* popup.�h]�(hJ�iTo discard a security label, click the trash icon to the left of the row and146confirm the deletion in the �����}�(h jVh!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�147Delete Row�����}�(h j^h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jVubhJ� popup.�����}�(h jVh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKqh h&h!hubhV)��}�(h� Click the *SQL* tab to continue.�h]�(hJ�148Click the �����}�(h jvh!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h j~h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jvubhJ� tab to continue.�����}�(h jvh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKth h&h!hubhV)��}�(h��Your entries in the *Login/Group Role* dialog generate a SQL command (see an149example below). Use the *SQL* tab for review; revisit or switch tabs to make150any changes to the SQL command.�h]�(hJ�Your entries in the �����}�(h j�h!hh"NhNubh`)��}�(h�*Login/Group Role*�h]�hJ�Login/Group Role�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�? dialog generate a SQL command (see an151example 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 make152any changes to the SQL command.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKvh 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#hK{ubhV)��}�(h�mThe following is an example of the sql command generated by user selections in153the *Login/Group Role* dialog:�h]�(hJ�SThe following is an example of the sql command generated by user selections in154the �����}�(h j�h!hh"NhNubh`)��}�(h�*Login/Group Role*�h]�hJ�Login/Group Role�����}�(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#hK}h j�h!hubj)��}�(h�P.. image:: images/role_sql.png155    :alt: Role dialog sql tab156    :align: center157�h]�h}�(h]�h]�h]�h]�h]��alt��Role dialog sql tab��align��center��uri��images/role_sql.png�j)}�j+jsuhjh"h#hK�h j�h!hubhV)��}�(h��The example creates a login role named *alice* with *pg_signal_backend* privileges; the158role can make unlimited connections to the server at any given time.�h]�(hJ�'The example creates a login role named �����}�(h j159h!hh"NhNubh`)��}�(h�*alice*�h]�hJ�alice�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j160ubhJ� with �����}�(h j161h!hh"NhNubh`)��}�(h�*pg_signal_backend*�h]�hJ�pg_signal_backend�����}�(h j$h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j162ubhJ�U privileges; the163role can make unlimited connections to the server at any given time.�����}�(h j164h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�h!hubjM)��}�(hhh]�(jR)��}�(h�6Click the Info button (*i*) to access online SQL help.�h]�hV)��}�(hjAh]�(hJ�Click the Info button (�����}�(h jCh!hh"NhNubh`)��}�(h�*i*�h]�hJ�i�����}�(h jJh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jCubhJ�) to access online SQL help.�����}�(h jCh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j?ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK�h j<h!hubjR)��}�(h�GClick the Help button (*?*) to access the documentation for the dialog.�h]�hV)��}�(hjjh]�(hJ�Click the Help button (�����}�(h jlh!hh"NhNubh`)��}�(h�*?*�h]�hJ�?�����}�(h jsh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jlubhJ�-) to access the documentation for the dialog.�����}�(h jlh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jhubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK�h j<h!hubjR)��}�(h�%Click the *Save* button to save work.�h]�hV)��}�(hj�h]�(hJ�165Click 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]�uhjQh"h#hK�h j<h!hubjR)��}�(h�5Click the *Close* button to exit without saving work.�h]�hV)��}�(hj�h]�(hJ�166Click 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]�uhjQh"h#hK�h j<h!hubjR)��}�(h�>Click the *Reset* button to restore configuration parameters.167�h]�hV)��}�(h�=Click the *Reset* button to restore configuration parameters.�h]�(hJ�168Click 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#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjQh"h#hK�h j<h!hubeh}�(h]�h]�h]�h]�h]�j�j+uhjLh"h#hK�h j�h!hubeh}�(h]��example�ah]�h]��example�ah]�h]�uhh$h h&h!hh"h#hK{ubeh}�(h]�(�login-group-role-dialog�heh]�h]�(�login/group role dialog��role_dialog�eh]�h]�uhh$h hh!hh"h#hK�expect_referenced_by_name�}�j!	hs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K�169translated�Kuuhh�current_source�N�current_line�N�settings��docutils.frontend��Values���)��}�(�output�Nh)N�	generator�N�	datestamp�N�root_prefix��/��source_link�N�170source_url�N�
toc_backlinks��entry��footnote_backlinks���
sectnum_xform���strip_comments�N�strip_elements_with_classes�N�
strip_classes�N�report_level�K�171halt_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�jR	�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�}�(j!	hj 	j	j	j	u�	nametypes�}�(j!	�j 	�j	�uh}�(hh&j	h&j	j�u�
footnote_refs�}��
citation_refs�}��
autofootnotes�]��autofootnote_refs�]��symbol_footnotes�]��symbol_footnote_refs�]��	footnotes�]��	citations�]��autofootnote_start�K�symbol_footnote_start�K�172id_counter��collections��Counter���}���R��parse_messages�]��transform_messages�]�(h	�system_message���)��}�(hhh]�hV)��}�(hhh]�hJ�1Hyperlink target "role-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�]��173decoration�Nh!hub.
codekingpro/portable-devtools · Team Ai