From 46651ce6fe013220ed397add242004d764fc0153 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:15:05 +0200 Subject: Adding upstream version 14.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-reassign-owned.html | 42 +++++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 doc/src/sgml/html/sql-reassign-owned.html (limited to 'doc/src/sgml/html/sql-reassign-owned.html') diff --git a/doc/src/sgml/html/sql-reassign-owned.html b/doc/src/sgml/html/sql-reassign-owned.html new file mode 100644 index 0000000..2253d31 --- /dev/null +++ b/doc/src/sgml/html/sql-reassign-owned.html @@ -0,0 +1,42 @@ + +REASSIGN OWNED
REASSIGN OWNED
Prev UpSQL CommandsHome Next

REASSIGN OWNED

REASSIGN OWNED — change the ownership of database objects owned by a database role

Synopsis

+REASSIGN OWNED BY { old_role | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...]
+               TO { new_role | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
+

Description

+ REASSIGN OWNED instructs the system to change + the ownership of database objects owned by any of the + old_roles to + new_role. +

Parameters

old_role

+ 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 + new_role. +

new_role

+ The name of the role that will be made the new owner of the + affected objects. +

Notes

+ REASSIGN OWNED is often used to prepare for the + removal of one or more roles. Because REASSIGN + OWNED 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. +

+ REASSIGN OWNED requires membership on both the + source role(s) and the target role. +

+ The DROP OWNED command is an alternative that + simply drops all the database objects owned by one or more roles. +

+ The REASSIGN OWNED command does not affect any + privileges granted to + the old_roles on objects + that are not owned by them. Likewise, it does not affect default + privileges created with ALTER DEFAULT PRIVILEGES. + Use DROP OWNED to revoke such privileges. +

+ See Section 22.4 for more discussion. +

Compatibility

+ The REASSIGN OWNED command is a + PostgreSQL extension. +

Prev Up Next
PREPARE TRANSACTION Home REFRESH MATERIALIZED VIEW
\ No newline at end of file -- cgit v1.2.3