Hackfut Security File Manager
Current Path:
/opt/td-agent/embedded/share/man/man7
opt
/
td-agent
/
embedded
/
share
/
man
/
man7
/
📁
..
📄
ABORT.7
(2.17 KB)
📄
ALTER_AGGREGATE.7
(4.97 KB)
📄
ALTER_COLLATION.7
(2.8 KB)
📄
ALTER_CONVERSION.7
(2.89 KB)
📄
ALTER_DATABASE.7
(5.71 KB)
📄
ALTER_DEFAULT_PRIVILEGES.7
(6.34 KB)
📄
ALTER_DOMAIN.7
(6.96 KB)
📄
ALTER_EVENT_TRIGGER.7
(2.42 KB)
📄
ALTER_EXTENSION.7
(6.89 KB)
📄
ALTER_FOREIGN_DATA_WRAPPER.7
(4.56 KB)
📄
ALTER_FOREIGN_TABLE.7
(12.8 KB)
📄
ALTER_FUNCTION.7
(8.26 KB)
📄
ALTER_GROUP.7
(3.08 KB)
📄
ALTER_INDEX.7
(5.59 KB)
📄
ALTER_LANGUAGE.7
(2.1 KB)
📄
ALTER_LARGE_OBJECT.7
(1.97 KB)
📄
ALTER_MATERIALIZED_VIEW.7
(4.66 KB)
📄
ALTER_OPERATOR.7
(3.67 KB)
📄
ALTER_OPERATOR_CLASS.7
(2.86 KB)
📄
ALTER_OPERATOR_FAMILY.7
(9.12 KB)
📄
ALTER_POLICY.7
(2.88 KB)
📄
ALTER_ROLE.7
(9.04 KB)
📄
ALTER_RULE.7
(2.21 KB)
📄
ALTER_SCHEMA.7
(2.31 KB)
📄
ALTER_SEQUENCE.7
(7.53 KB)
📄
ALTER_SERVER.7
(3.41 KB)
📄
ALTER_SYSTEM.7
(3.8 KB)
📄
ALTER_TABLE.7
(35.2 KB)
📄
ALTER_TABLESPACE.7
(3.35 KB)
📄
ALTER_TEXT_SEARCH_CONFIGURATION.7
(4.79 KB)
📄
ALTER_TEXT_SEARCH_DICTIONARY.7
(4.02 KB)
📄
ALTER_TEXT_SEARCH_PARSER.7
(2.23 KB)
📄
ALTER_TEXT_SEARCH_TEMPLATE.7
(2.26 KB)
📄
ALTER_TRIGGER.7
(2.98 KB)
📄
ALTER_TYPE.7
(7.15 KB)
📄
ALTER_USER.7
(2.66 KB)
📄
ALTER_USER_MAPPING.7
(3.26 KB)
📄
ALTER_VIEW.7
(4.67 KB)
📄
ANALYZE.7
(7.67 KB)
📄
BEGIN.7
(4.06 KB)
📄
CHECKPOINT.7
(2.29 KB)
📄
CLOSE.7
(2.72 KB)
📄
CLUSTER.7
(6.23 KB)
📄
COMMENT.7
(10.2 KB)
📄
COMMIT.7
(2.1 KB)
📄
COMMIT_PREPARED.7
(2.58 KB)
📄
COPY.7
(29.88 KB)
📄
CREATE_ACCESS_METHOD.7
(2.9 KB)
📄
CREATE_AGGREGATE.7
(23.35 KB)
📄
CREATE_CAST.7
(13.55 KB)
📄
CREATE_COLLATION.7
(3.97 KB)
📄
CREATE_CONVERSION.7
(3.78 KB)
📄
CREATE_DATABASE.7
(8.48 KB)
📄
CREATE_DOMAIN.7
(6.52 KB)
📄
CREATE_EVENT_TRIGGER.7
(3.74 KB)
📄
CREATE_EXTENSION.7
(6.57 KB)
📄
CREATE_FOREIGN_DATA_WRAPPER.7
(4.96 KB)
📄
CREATE_FOREIGN_TABLE.7
(9 KB)
📄
CREATE_FUNCTION.7
(24.73 KB)
📄
CREATE_GROUP.7
(2.11 KB)
📄
CREATE_INDEX.7
(19.56 KB)
📄
CREATE_LANGUAGE.7
(9.83 KB)
📄
CREATE_MATERIALIZED_VIEW.7
(4.21 KB)
📄
CREATE_OPERATOR.7
(6.88 KB)
📄
CREATE_OPERATOR_CLASS.7
(8.52 KB)
📄
CREATE_OPERATOR_FAMILY.7
(3.6 KB)
📄
CREATE_POLICY.7
(15.92 KB)
📄
CREATE_ROLE.7
(12.69 KB)
📄
CREATE_RULE.7
(8.63 KB)
📄
CREATE_SCHEMA.7
(6.15 KB)
📄
CREATE_SEQUENCE.7
(9.79 KB)
📄
CREATE_SERVER.7
(3.63 KB)
📄
CREATE_TABLE.7
(42.1 KB)
📄
CREATE_TABLESPACE.7
(4.47 KB)
📄
CREATE_TABLE_AS.7
(7.8 KB)
📄
CREATE_TEXT_SEARCH_CONFIGURATION.7
(3.19 KB)
📄
CREATE_TEXT_SEARCH_DICTIONARY.7
(3.34 KB)
📄
CREATE_TEXT_SEARCH_PARSER.7
(3.56 KB)
📄
CREATE_TEXT_SEARCH_TEMPLATE.7
(3.38 KB)
📄
CREATE_TRANSFORM.7
(5.79 KB)
📄
CREATE_TRIGGER.7
(16.3 KB)
📄
CREATE_TYPE.7
(28.96 KB)
📄
CREATE_USER.7
(2.45 KB)
📄
CREATE_USER_MAPPING.7
(3.27 KB)
📄
CREATE_VIEW.7
(14.63 KB)
📄
DEALLOCATE.7
(1.98 KB)
📄
DECLARE.7
(10.22 KB)
📄
DELETE.7
(7.36 KB)
📄
DISCARD.7
(2.81 KB)
📄
DO.7
(3.08 KB)
📄
DROP_ACCESS_METHOD.7
(2.35 KB)
📄
DROP_AGGREGATE.7
(3.8 KB)
📄
DROP_CAST.7
(2.26 KB)
📄
DROP_COLLATION.7
(2.42 KB)
📄
DROP_CONVERSION.7
(2.36 KB)
📄
DROP_DATABASE.7
(2.38 KB)
📄
DROP_DOMAIN.7
(2.34 KB)
📄
DROP_EVENT_TRIGGER.7
(2.38 KB)
📄
DROP_EXTENSION.7
(2.73 KB)
📄
DROP_FOREIGN_DATA_WRAPPER.7
(2.61 KB)
📄
DROP_FOREIGN_TABLE.7
(2.59 KB)
📄
DROP_FUNCTION.7
(3.35 KB)
📄
DROP_GROUP.7
(1.57 KB)
📄
DROP_INDEX.7
(3.08 KB)
📄
DROP_LANGUAGE.7
(2.86 KB)
📄
DROP_MATERIALIZED_VIEW.7
(2.64 KB)
📄
DROP_OPERATOR.7
(3.01 KB)
📄
DROP_OPERATOR_CLASS.7
(3.48 KB)
📄
DROP_OPERATOR_FAMILY.7
(3.24 KB)
📄
DROP_OWNED.7
(3.14 KB)
📄
DROP_POLICY.7
(2.53 KB)
📄
DROP_ROLE.7
(3.05 KB)
📄
DROP_RULE.7
(2.35 KB)
📄
DROP_SCHEMA.7
(2.76 KB)
📄
DROP_SEQUENCE.7
(2.46 KB)
📄
DROP_SERVER.7
(2.39 KB)
📄
DROP_TABLE.7
(2.97 KB)
📄
DROP_TABLESPACE.7
(2.48 KB)
📄
DROP_TEXT_SEARCH_CONFIGURATION.7
(2.83 KB)
📄
DROP_TEXT_SEARCH_DICTIONARY.7
(2.75 KB)
📄
DROP_TEXT_SEARCH_PARSER.7
(2.66 KB)
📄
DROP_TEXT_SEARCH_TEMPLATE.7
(2.69 KB)
📄
DROP_TRANSFORM.7
(2.59 KB)
📄
DROP_TRIGGER.7
(2.6 KB)
📄
DROP_TYPE.7
(2.53 KB)
📄
DROP_USER.7
(1.65 KB)
📄
DROP_USER_MAPPING.7
(2.56 KB)
📄
DROP_VIEW.7
(2.43 KB)
📄
END.7
(2.19 KB)
📄
EXECUTE.7
(2.9 KB)
📄
EXPLAIN.7
(13.03 KB)
📄
FETCH.7
(8.48 KB)
📄
GRANT.7
(21.29 KB)
📄
IMPORT_FOREIGN_SCHEMA.7
(3.98 KB)
📄
INSERT.7
(19.61 KB)
📄
LISTEN.7
(3.51 KB)
📄
LOAD.7
(2.54 KB)
📄
LOCK.7
(8.01 KB)
📄
MOVE.7
(2.92 KB)
📄
NOTIFY.7
(8.21 KB)
📄
PREPARE.7
(8.2 KB)
📄
PREPARE_TRANSACTION.7
(5.74 KB)
📄
REASSIGN_OWNED.7
(3.01 KB)
📄
REFRESH_MATERIALIZED_VIEW.7
(3.92 KB)
📄
REINDEX.7
(7.69 KB)
📄
RELEASE_SAVEPOINT.7
(3 KB)
📄
RESET.7
(2.93 KB)
📄
REVOKE.7
(10.44 KB)
📄
ROLLBACK.7
(2.09 KB)
📄
ROLLBACK_PREPARED.7
(2.6 KB)
📄
ROLLBACK_TO_SAVEPOINT.7
(3.94 KB)
📄
SAVEPOINT.7
(3.5 KB)
📄
SECURITY_LABEL.7
(5.39 KB)
📄
SELECT.7
(63.33 KB)
📄
SELECT_INTO.7
(4.37 KB)
📄
SET.7
(7.57 KB)
📄
SET_CONSTRAINTS.7
(4.48 KB)
📄
SET_ROLE.7
(4.36 KB)
📄
SET_SESSION_AUTHORIZATION.7
(3.88 KB)
📄
SET_TRANSACTION.7
(8.27 KB)
📄
SHOW.7
(4.22 KB)
📄
START_TRANSACTION.7
(2.9 KB)
📄
TABLE.7
(18 B)
📄
TRUNCATE.7
(6.39 KB)
📄
UNLISTEN.7
(2.75 KB)
📄
UPDATE.7
(12.26 KB)
📄
VACUUM.7
(7.92 KB)
📄
VALUES.7
(6.94 KB)
📄
WITH.7
(18 B)
Editing: DROP_OWNED.7
'\" t .\" Title: DROP OWNED .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/> .\" Date: 2018 .\" Manual: PostgreSQL 9.6.9 Documentation .\" Source: PostgreSQL 9.6.9 .\" Language: English .\" .TH "DROP OWNED" "7" "2018" "PostgreSQL 9.6.9" "PostgreSQL 9.6.9 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" DROP_OWNED \- remove database objects owned by a database role .SH "SYNOPSIS" .sp .nf DROP OWNED BY { \fIname\fR | CURRENT_USER | SESSION_USER } [, \&.\&.\&.] [ CASCADE | RESTRICT ] .fi .SH "DESCRIPTION" .PP \fBDROP OWNED\fR drops all the objects within the current database that are owned by one of the specified roles\&. Any privileges granted to the given roles on objects in the current database and on shared objects (databases, tablespaces) will also be revoked\&. .SH "PARAMETERS" .PP \fIname\fR .RS 4 The name of a role whose objects will be dropped, and whose privileges will be revoked\&. .RE .PP CASCADE .RS 4 Automatically drop objects that depend on the affected objects, and in turn all objects that depend on those objects (see Section 5.13, \(lqDependency Tracking\(rq, in the documentation)\&. .RE .PP RESTRICT .RS 4 Refuse to drop the objects owned by a role if any other database objects depend on one of the affected objects\&. This is the default\&. .RE .SH "NOTES" .PP \fBDROP OWNED\fR is often used to prepare for the removal of one or more roles\&. Because \fBDROP OWNED\fR only affects the objects in the current database, it is usually necessary to execute this command in each database that contains objects owned by a role that is to be removed\&. .PP Using the CASCADE option might make the command recurse to objects owned by other users\&. .PP The REASSIGN OWNED (\fBREASSIGN_OWNED\fR(7)) command is an alternative that reassigns the ownership of all the database objects owned by one or more roles\&. However, \fBREASSIGN OWNED\fR does not deal with privileges for other objects\&. .PP Databases and tablespaces owned by the role(s) will not be removed\&. .PP See Section 21.4, \(lqDropping Roles\(rq, in the documentation for more discussion\&. .SH "COMPATIBILITY" .PP The \fBDROP OWNED\fR command is a PostgreSQL extension\&. .SH "SEE ALSO" REASSIGN OWNED (\fBREASSIGN_OWNED\fR(7)), DROP ROLE (\fBDROP_ROLE\fR(7))
Upload File
Create Folder