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>Grant Wizard — 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="Import/Export Data Dialog" href="import_export_data.html" />
23 <link rel="prev" title="Change Password Dialog" href="change_password_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="import_export_data.html" title="Import/Export Data Dialog"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="change_password_dialog.html" title="Change Password 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="management_basics.html" accesskey="U">Management Basics</a> »</li>
39 <li class="nav-item nav-item-this"><a href="">Grant Wizard</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="grant-wizard">
49<span id="id1"></span><h1><span class="target" id="index-0"></span>Grant Wizard<a class="headerlink" href="#grant-wizard" title="Link to this heading">¶</a></h1>
50<p>The <em>Grant Wizard</em> tool is a graphical interface that allows you to manage the
51privileges of one or more database objects in a point-and-click environment. A
52search box, dropdown lists, and checkboxes facilitate quick selections of
53database objects, roles and privileges.</p>
54<p>The wizard organizes privilege management through a sequence of windows:
55<em>Object Selection</em>, <em>Privileges Selection</em> and
56<em>Review Selection</em>. The <em>Review Selection</em> window
57displays the SQL code generated by wizard selections.</p>
58<p>To launch the <em>Grant Wizard</em> tool, select a database object in the <em>pgAdmin</em>
59tree control, then navigate through <em>Tools</em> on the menu bar to click on the
60<em>Grant Wizard</em> option.</p>
61<img alt="Grant wizard step one page" class="align-center" src="_images/grant_wizard_step1.png" />
62<p>Use the fields in the <em>Object Selection</em> window to select the
63object or objects on which you are modifying privileges. Use the <em>Search by
64object type or name</em> field to locate a database object, or use the scrollbar
65to scroll through the list of all accessible objects.</p>
66<ul>
67<li><p>Each row in the table lists object identifiers; check the checkbox in the left
68column to include an object as a target of the Grant Wizard. The table
69displays:</p>
70<blockquote>
71<div><ul class="simple">
72<li><p>The object type in the <em>Object Type</em> field</p></li>
73<li><p>The schema in which the object resides in the <em>Schema</em> field</p></li>
74<li><p>The object name in the <em>Name</em> field.</p></li>
75</ul>
76</div></blockquote>
77</li>
78</ul>
79<p>Click the <em>Next</em> button to continue, or the <em>X</em> button to close the wizard
80without modifying privileges.</p>
81<img alt="Grant wizard step two page" class="align-center" src="_images/grant_wizard_step2.png" />
82<p>Use the fields in the <em>Privileges Selection</em> window to grant
83privileges. If you grant a privilege WITH GRANT OPTION, the Grantee will have
84the right to grant privileges on the object to others. If WITH GRANT OPTION is
85subsequently revoked, any role who received access to that object from that
86Grantee (directly or through a chain of grants) will lose thier privileges on
87the object.</p>
88<ul class="simple">
89<li><p>Click the <em>Add</em> icon (+) to assign a set of privileges.</p></li>
90<li><p>Select the name of the role from the drop-down listbox in the <em>Grantee</em> field.</p></li>
91<li><p>Click inside the <em>Privileges</em> field. Check the boxes to the left of one or
92more privileges to grant the selected privileges to the specified user. If
93privileges have previously been granted on a database object, unchecking a
94privilege for a group or user will result in revoking that privilege.</p></li>
95<li><p>The current user, who is the default grantor for granting the privilege, is displayed in the <em>Grantor</em> field.</p></li>
96<li><p>Click the <em>Add</em> icon (+) to assign a set of privileges to another role; to
97discard a privilege, click the trash icon to the left of the row and confirm
98deletion in the <em>Delete Row</em> dialog.</p></li>
99</ul>
100<p>For more information about granting privileges on database objects, see the
101<a class="reference external" href="https://www.postgresql.org/docs/current/sql-grant.html">PostgreSQL core documentation</a>.</p>
102<p>Click the <em>Next</em> button to continue, the <em>Back</em> button to select or deselect
103additional database objects, or the <em>X</em> button to close the wizard without
104modifying privileges.</p>
105<p>Your entries in the <em>Grant Wizard</em> tool generate a SQL command; you can review
106the command in the <em>Review Selection</em> window (see an
107example below).</p>
108<section id="example">
109<h2>Example<a class="headerlink" href="#example" title="Link to this heading">¶</a></h2>
110<p>The following is an example of the sql command generated by user selections in
111the <em>Grant Wizard</em> tool:</p>
112<img alt="Grant wizard step three page" class="align-center" src="_images/grant_wizard_step3.png" />
113<ul class="simple">
114<li><p>Click the <em>Back</em> button to select or deselect additional database objects,
115roles and privileges.</p></li>
116<li><p>Click the <em>Finish</em> button to save selections and exit the wizard.</p></li>
117</ul>
118</section>
119</section>
120
121
122 <div class="clearer"></div>
123 </div>
124 </div>
125 </div>
126 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
127 <div class="sphinxsidebarwrapper">
128 <div>
129 <h3><a href="index.html">Table of Contents</a></h3>
130 <ul>
131<li><a class="reference internal" href="#">Grant Wizard</a><ul>
132<li><a class="reference internal" href="#example">Example</a></li>
133</ul>
134</li>
135</ul>
136
137 </div>
138<h3><a href="index.html">Table of Contents</a></h3>
139<ul class="current">
140<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
141<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
142<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
143<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
144<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
145<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
146<li class="toctree-l1 current"><a class="reference internal" href="management_basics.html">Management Basics</a><ul class="current">
147<li class="toctree-l2"><a class="reference internal" href="add_restore_point_dialog.html">Add Named Restore Point Dialog</a></li>
148<li class="toctree-l2"><a class="reference internal" href="change_password_dialog.html">Change Password Dialog</a></li>
149<li class="toctree-l2 current"><a class="current reference internal" href="#">Grant Wizard</a></li>
150<li class="toctree-l2"><a class="reference internal" href="import_export_data.html">Import/Export Data Dialog</a></li>
151<li class="toctree-l2"><a class="reference internal" href="maintenance_dialog.html">Maintenance Dialog</a></li>
152<li class="toctree-l2"><a class="reference internal" href="storage_manager.html">Storage Manager</a></li>
153</ul>
154</li>
155<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
156<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
157<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
158<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
159<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
160<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
161<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
162</ul>
163
164<search id="searchbox" style="display: none" role="search">
165 <h3 id="searchlabel">Quick search</h3>
166 <div class="searchformwrapper">
167 <form class="search" action="search.html" method="get">
168 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
169 <input type="submit" value="Go" />
170 </form>
171 </div>
172</search>
173<script>document.getElementById('searchbox').style.display = "block"</script>
174 </div>
175<div id="sidebarbutton" title="Collapse sidebar">
176<span>«</span>
177</div>
178
179 </div>
180 <div class="clearer"></div>
181 </div>
182 <div class="related" role="navigation" aria-label="related navigation">
183 <h3>Navigation</h3>
184 <ul>
185 <li class="right" style="margin-right: 10px">
186 <a href="genindex.html" title="General Index"
187 >index</a></li>
188 <li class="right" >
189 <a href="import_export_data.html" title="Import/Export Data Dialog"
190 >next</a> |</li>
191 <li class="right" >
192 <a href="change_password_dialog.html" title="Change Password Dialog"
193 >previous</a> |</li>
194 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
195 <li class="nav-item nav-item-1"><a href="management_basics.html" >Management Basics</a> »</li>
196 <li class="nav-item nav-item-this"><a href="">Grant Wizard</a></li>
197 </ul>
198 </div>
199 <div class="footer" role="contentinfo">
200 <div class="related" role="navigation" aria-label="related navigation">
201 <ul>
202 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
203 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
204 <li class="right" ><a href="import_export_data.html" title="Import/Export Data Dialog" accesskey="N">next</a> |</li>
205 <li class="right" ><a href="change_password_dialog.html" title="Change Password Dialog" accesskey="P">previous</a> |</li>
206 </ul>
207 </div>
208 </div>
209 </body>
210</html>