One Hat Cyber Team
Your IP :
216.73.216.115
Server IP :
194.44.31.54
Server :
Linux zen.imath.kiev.ua 4.18.0-553.77.1.el8_10.x86_64 #1 SMP Fri Oct 3 14:30:23 UTC 2025 x86_64
Server Software :
Apache/2.4.37 (Rocky Linux) OpenSSL/1.1.1k
PHP Version :
5.6.40
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
usr
/
pgsql-13
/
share
/
man
/
man7
/
Edit File:
REASSIGN_OWNED.7
'\" t .\" Title: REASSIGN OWNED .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets vsnapshot <http://docbook.sf.net/> .\" Date: 2023 .\" Manual: PostgreSQL 13.13 Documentation .\" Source: PostgreSQL 13.13 .\" Language: English .\" .TH "REASSIGN OWNED" "7" "2023" "PostgreSQL 13.13" "PostgreSQL 13.13 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" REASSIGN_OWNED \- change the ownership of database objects owned by a database role .SH "SYNOPSIS" .sp .nf REASSIGN OWNED BY { \fIold_role\fR | CURRENT_USER | SESSION_USER } [, \&.\&.\&.] TO { \fInew_role\fR | CURRENT_USER | SESSION_USER } .fi .SH "DESCRIPTION" .PP \fBREASSIGN OWNED\fR instructs the system to change the ownership of database objects owned by any of the \fIold_roles\fR to \fInew_role\fR\&. .SH "PARAMETERS" .PP \fIold_role\fR .RS 4 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 \fInew_role\fR\&. .RE .PP \fInew_role\fR .RS 4 The name of the role that will be made the new owner of the affected objects\&. .RE .SH "NOTES" .PP \fBREASSIGN OWNED\fR is often used to prepare for the removal of one or more roles\&. Because \fBREASSIGN OWNED\fR 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\&. .PP \fBREASSIGN OWNED\fR requires membership on both the source role(s) and the target role\&. .PP The DROP OWNED (\fBDROP_OWNED\fR(7)) command is an alternative that simply drops all the database objects owned by one or more roles\&. .PP The \fBREASSIGN OWNED\fR command does not affect any privileges granted to the \fIold_roles\fR on objects that are not owned by them\&. Likewise, it does not affect default privileges created with \fBALTER DEFAULT PRIVILEGES\fR\&. Use \fBDROP OWNED\fR to revoke such privileges\&. .PP See Section\ \&21.4 for more discussion\&. .SH "COMPATIBILITY" .PP The \fBREASSIGN OWNED\fR command is a PostgreSQL extension\&. .SH "SEE ALSO" DROP OWNED (\fBDROP_OWNED\fR(7)), DROP ROLE (\fBDROP_ROLE\fR(7)), ALTER DATABASE (\fBALTER_DATABASE\fR(7))
Simpan