Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

LikeSaveClone

rootpgsqlpgAdmin 4docsen_UShtmlrole_reassign_dialog.html

role_reassign_dialog.html160 linesCopy pathDownload Raw Back to html

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>Role Reassign/Drop Own Dialog &#8212; 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="Managing Database Objects" href="managing_database_objects.html" />
23    <link rel="prev" title="Replica Node Dialog" href="replica_nodes_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="managing_database_objects.html" title="Managing Database Objects"
33             accesskey="N">next</a> |</li>
34        <li class="right" >
35          <a href="replica_nodes_dialog.html" title="Replica Node 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> &#187;</li>
38          <li class="nav-item nav-item-1"><a href="managing_cluster_objects.html" accesskey="U">Managing Cluster Objects</a> &#187;</li>
39        <li class="nav-item nav-item-this"><a href="">Role Reassign/Drop Own 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="role-reassign-drop-own-dialog">
49<span id="role-reassign-dialog"></span><h1><span class="target" id="index-0"></span>Role Reassign/Drop Own Dialog<a class="headerlink" href="#role-reassign-drop-own-dialog" title="Link to this heading">¶</a></h1>
50<p>Use the <em>Reassign/Drop Own</em> dialog to change the ownership of database objects owned
51by a database role. This dialog instructs the system to change the ownership of database
52objects owned by any of the <em>old_roles</em> to <em>new_role</em>.</p>
53<p>The <em>Reassign/Drop Own</em> dialog organizes the Reassign &amp; Drop role through General tab.</p>
54<img alt="Reassign/Drop Own dialog" class="align-center" src="_images/role_reassign_dialog.png" />
55<ul class="simple">
56<li><p>Use the <em>Operation</em> field to provide Reassign option.</p></li>
57<li><p>Provide a new role in the <em>Reassign Objects to</em> field; The ownership of all the objects within the selected database,
58and of all shared objects (databases, tablespaces), owned by the <em>old_role</em> will be reassigned to <em>new_role</em>.</p></li>
59<li><p>Provide a database on which the reassignment is to be carried out.</p></li>
60</ul>
61<p>The above example demonstrates reassigning <em>old_role</em> to <em>new_role</em>.</p>
62<p>Click the <em>SQL</em> tab to continue.</p>
63<img alt="Reassign/Drop Own dialog sql" class="align-center" src="_images/role_reassign_dialog_sql.png" />
64<p>Removing database objects owned by a database role.</p>
65<img alt="Reassign/Drop Own dialog" class="align-center" src="_images/role_drop_dialog.png" />
66<ul class="simple">
67<li><p>Use the <em>Operation</em> field to provide Drop option.</p></li>
68<li><p>Use the <em>Cascade?</em> field to provide Yes, No is default.</p></li>
69<li><p>Provide a database on which the drop of objects is to be carried out.</p></li>
70</ul>
71<p>Click the <em>SQL</em> tab to continue.</p>
72<img alt="Reassign/Drop Own dialog sql" class="align-center" src="_images/role_drop_dialog_sql.png" />
73<p>The above examples demonstrates drop owned by <em>role</em>.</p>
74<ul class="simple">
75<li><p>Click the <em>Help</em> button (?) to access online help.</p></li>
76<li><p>Click the <em>OK</em> button to save work.</p></li>
77<li><p>Click the <em>Cancel</em> button to exit without saving work.</p></li>
78</ul>
79</section>
80
81
82            <div class="clearer"></div>
83          </div>
84        </div>
85      </div>
86      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
87        <div class="sphinxsidebarwrapper">
88<h3><a href="index.html">Table of Contents</a></h3>
89<ul class="current">
90<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
91<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
92<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
93<li class="toctree-l1 current"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a><ul class="current">
94<li class="toctree-l2"><a class="reference internal" href="database_dialog.html">Database Dialog</a></li>
95<li class="toctree-l2"><a class="reference internal" href="resource_group_dialog.html">Resource Group Dialog</a></li>
96<li class="toctree-l2"><a class="reference internal" href="role_dialog.html">Login/Group Role Dialog</a></li>
97<li class="toctree-l2"><a class="reference internal" href="tablespace_dialog.html">Tablespace Dialog</a></li>
98<li class="toctree-l2"><a class="reference internal" href="replica_nodes_dialog.html">Replica Node Dialog</a></li>
99<li class="toctree-l2 current"><a class="current reference internal" href="#">Role Reassign/Drop Own Dialog</a></li>
100</ul>
101</li>
102<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
103<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
104<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
105<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
106<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
107<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
108<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
109<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
110<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
111<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
112</ul>
113
114<search id="searchbox" style="display: none" role="search">
115  <h3 id="searchlabel">Quick search</h3>
116    <div class="searchformwrapper">
117    <form class="search" action="search.html" method="get">
118      <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
119      <input type="submit" value="Go" />
120    </form>
121    </div>
122</search>
123<script>document.getElementById('searchbox').style.display = "block"</script>
124        </div>
125<div id="sidebarbutton" title="Collapse sidebar">
126<span>«</span>
127</div>
128
129      </div>
130      <div class="clearer"></div>
131    </div>
132    <div class="related" role="navigation" aria-label="related navigation">
133      <h3>Navigation</h3>
134      <ul>
135        <li class="right" style="margin-right: 10px">
136          <a href="genindex.html" title="General Index"
137             >index</a></li>
138        <li class="right" >
139          <a href="managing_database_objects.html" title="Managing Database Objects"
140             >next</a> |</li>
141        <li class="right" >
142          <a href="replica_nodes_dialog.html" title="Replica Node Dialog"
143             >previous</a> |</li>
144        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
145          <li class="nav-item nav-item-1"><a href="managing_cluster_objects.html" >Managing Cluster Objects</a> &#187;</li>
146        <li class="nav-item nav-item-this"><a href="">Role Reassign/Drop Own Dialog</a></li> 
147      </ul>
148    </div>
149    <div class="footer" role="contentinfo">
150        <div class="related" role="navigation" aria-label="related navigation">
151          <ul>
152              <li class="left" style="margin-left: 10px">&#169; Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
153            <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
154            <li class="right" ><a href="managing_database_objects.html" title="Managing Database Objects" accesskey="N">next</a> |</li>
155            <li class="right" ><a href="replica_nodes_dialog.html" title="Replica Node Dialog" accesskey="P">previous</a> |</li>
156          </ul>
157        </div>
158    </div>
159  </body>
160</html>