codekingpro/portable-devtools
114k
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)��}�(hX The *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( suhj h"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 j4 h!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 jW h!hh"NhNubh`)��}�(h�*Name*�h]�hJ�Name�����}�(h j_ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jW ubhJ�W field to provide the name of the role. The name will be25displayed in the tree control.�����}�(h jW h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jS ubah}�(h]�h]�h]�h]�h]�uhjQ h"h#hKh jN h!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]�uhjQ h"h#hKh jN h!hubeh}�(h]�h]�h]�h]�h]��bullet�j+ uhjL h"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� suhj h"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 j h!hh"NhNubh`)��}�(h�36*Password*�h]�hJ�Password�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�37field.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h j ubah}�(h]�h]�h]�h]�h]�uhjQ h"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 j0 h!hh"NhNubh`)��}�(h�*Account Expires*�h]�hJ�Account Expires�����}�(h j8 h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j0 ubhJ�� field42(the role does not expire). The expiration date is not enforced when a user43logs in with a non-password-based authentication method.�����}�(h j0 h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK$h j, ubah}�(h]�h]�h]�h]�h]�uhjQ h"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 jZ h!hh"NhNubh`)��}�(h�*Connection Limit*�h]�hJ�Connection Limit�����}�(h jb h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jZ ubhJ� field. The default value (�����}�(h jZ h!hh"NhNubh`)��}�(h�*-1*�h]�hJ�-1�����}�(h jt h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jZ ubhJ�) allows50unlimited connections.�����}�(h jZ h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h jV ubah}�(h]�h]�h]�h]�h]�uhjQ h"h#hK'h j� h!hubeh}�(h]�h]�h]�h]�h]�j� j+ uhjL h"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� suhj h"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 j60 h!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 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#hK3h j� ubah}�(h]�h]�h]�h]�h]�uhjQ h"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 jF 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 jX h!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 jj h!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]�uhjQ h"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]�uhjQ h"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 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#hK:h j� ubah}�(h]�h]�h]�h]�h]�uhjQ h"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 j0 h!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 jB h!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 jT h!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]�uhjQ h"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 jv h!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 jv ubhJ� switch to the �����}�(h jv h!hh"NhNubh`)��}�(h�*Yes*�h]�hJ�Yes�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jv ubhJ��81position to control whether a role can initiate streaming replication or put82the system in and out of backup mode. The default value is �����}�(h jv h!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jv ubhJ�.�����}�(h jv h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK>h jr ubah}�(h]�h]�h]�h]�h]�uhjQ h"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]�uhjQ h"h#hKAh j� h!hubeh}�(h]�h]�h]�h]�h]�j� j+ uhjL h"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# suhj h"h#hKDh h&h!hubjM )��}�(hhh]�jR )��}�(hXO Specify 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)��}�(hXN Specify 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 j4 h!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 jF h!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 jX h!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]�uhjQ h"h#hKHh j% h!hubah}�(h]�h]�h]�h]�h]�j� j+ uhjL h"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� suhj h"h#hKPh h&h!hubhV)��}�(hX Use 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]�uhjQ h"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 j h!hh"NhNubh`)��}�(h�*Value*�h]�hJ�Value�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�, field to specify a value for the parameter.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKZh j ubah}�(h]�h]�h]�h]�h]�uhjQ h"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 j8 h!hh"NhNubh`)��}�(h�116*Database*�h]�hJ�Database�����}�(h j@ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j8 ubhJ� field to select a database.�����}�(h j8 h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK[h j4 ubah}�(h]�h]�h]�h]�h]�uhjQ h"h#hK[h j� h!hubeh}�(h]�h]�h]�h]�h]�j� j+ uhjL h"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 jd h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h jl h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jd ubhJ�� 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 jd h!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�122Delete Row�����}�(h j~ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jd ubhJ� popup.�����}�(h jd h!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� suhj h"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 j h!hh"NhNubh`)��}�(h�133*Provider*�h]�hJ�Provider�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�^ field. The named provider134must be loaded and must consent to the proposed labeling operation.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKjh j� ubah}�(h]�h]�h]�h]�h]�uhjQ h"h#hKjh j� h!hubjR )��}�(hX Specify 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)��}�(hX Specify 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 j2 h!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]�uhjQ h"h#hKlh j� h!hubeh}�(h]�h]�h]�h]�h]�j� j+ uhjL h"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 jV h!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�147Delete Row�����}�(h j^ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jV ubhJ� popup.�����}�(h jV h!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 jv h!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h j~ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jv ubhJ� tab to continue.�����}�(h jv h!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+ j suhj h"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 j159 h!hh"NhNubh`)��}�(h�*alice*�h]�hJ�alice�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j160 ubhJ� with �����}�(h j161 h!hh"NhNubh`)��}�(h�*pg_signal_backend*�h]�hJ�pg_signal_backend�����}�(h j$ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j162 ubhJ�U privileges; the163role can make unlimited connections to the server at any given time.�����}�(h j164 h!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)��}�(hjA h]�(hJ�Click the Info button (�����}�(h jC h!hh"NhNubh`)��}�(h�*i*�h]�hJ�i�����}�(h jJ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jC ubhJ�) to access online SQL help.�����}�(h jC h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j? ubah}�(h]�h]�h]�h]�h]�uhjQ h"h#hK�h j< h!hubjR )��}�(h�GClick the Help button (*?*) to access the documentation for the dialog.�h]�hV)��}�(hjj h]�(hJ�Click the Help button (�����}�(h jl h!hh"NhNubh`)��}�(h�*?*�h]�hJ�?�����}�(h js h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jl ubhJ�-) to access the documentation for the dialog.�����}�(h jl h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jh ubah}�(h]�h]�h]�h]�h]�uhjQ h"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]�uhjQ h"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]�uhjQ h"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]�uhjQ h"h#hK�h j< h!hubeh}�(h]�h]�h]�h]�h]�j� j+ uhjL h"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! hs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K �169translated�K uuhh�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]�has�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.