blob: ab692bd06908b34334a75790739b667e0dc35c98 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
|
<!--
doc/src/sgml/ref/reassign_owned.sgml
PostgreSQL documentation
-->
<refentry id="sql-reassign-owned">
<indexterm zone="sql-reassign-owned">
<primary>REASSIGN OWNED</primary>
</indexterm>
<refmeta>
<refentrytitle>REASSIGN OWNED</refentrytitle>
<manvolnum>7</manvolnum>
<refmiscinfo>SQL - Language Statements</refmiscinfo>
</refmeta>
<refnamediv>
<refname>REASSIGN OWNED</refname>
<refpurpose>change the ownership of database objects owned by a database role</refpurpose>
</refnamediv>
<refsynopsisdiv>
<synopsis>
REASSIGN OWNED BY { <replaceable class="parameter">old_role</replaceable> | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...]
TO { <replaceable class="parameter">new_role</replaceable> | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Description</title>
<para>
<command>REASSIGN OWNED</command> instructs the system to change
the ownership of database objects owned by any of the
<replaceable class="parameter">old_roles</replaceable> to
<replaceable class="parameter">new_role</replaceable>.
</para>
</refsect1>
<refsect1>
<title>Parameters</title>
<variablelist>
<varlistentry>
<term><replaceable class="parameter">old_role</replaceable></term>
<listitem>
<para>
The name of a role. The ownership of all the objects within the
current database, and of all shared objects (databases, tablespaces),
owned by this role will be reassigned to
<replaceable class="parameter">new_role</replaceable>.
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><replaceable class="parameter">new_role</replaceable></term>
<listitem>
<para>
The name of the role that will be made the new owner of the
affected objects.
</para>
</listitem>
</varlistentry>
</variablelist>
</refsect1>
<refsect1>
<title>Notes</title>
<para>
<command>REASSIGN OWNED</command> is often used to prepare for the
removal of one or more roles. Because <command>REASSIGN
OWNED</command> does not affect objects within other databases,
it is usually necessary to execute this command in each database
that contains objects owned by a role that is to be removed.
</para>
<para>
<command>REASSIGN OWNED</command> requires membership on both the
source role(s) and the target role.
</para>
<para>
The <link linkend="sql-drop-owned"><command>DROP OWNED</command></link> command is an alternative that
simply drops all the database objects owned by one or more roles.
</para>
<para>
The <command>REASSIGN OWNED</command> command does not affect any
privileges granted to
the <replaceable class="parameter">old_roles</replaceable> on objects
that are not owned by them. Likewise, it does not affect default
privileges created with <command>ALTER DEFAULT PRIVILEGES</command>.
Use <command>DROP OWNED</command> to revoke such privileges.
</para>
<para>
See <xref linkend="role-removal"/> for more discussion.
</para>
</refsect1>
<refsect1>
<title>Compatibility</title>
<para>
The <command>REASSIGN OWNED</command> command is a
<productname>PostgreSQL</productname> extension.
</para>
</refsect1>
<refsect1>
<title>See Also</title>
<simplelist type="inline">
<member><xref linkend="sql-drop-owned"/></member>
<member><xref linkend="sql-droprole"/></member>
<member><xref linkend="sql-alterdatabase"/></member>
</simplelist>
</refsect1>
</refentry>
|
