Beta Shell v2.0

File Manager

Name	Size	Perms	Modified	Actions
[ .. / .. ]
ABORT.7	2.17 KB	-rw-r--r--	2021-11-08 22:28:37	Edit Del
ALTER_AGGREGATE.7	4.97 KB	-rw-r--r--	2021-11-08 22:28:37	Edit Del
ALTER_COLLATION.7	2.8 KB	-rw-r--r--	2021-11-08 22:28:37	Edit Del
ALTER_CONVERSION.7	2.9 KB	-rw-r--r--	2021-11-08 22:28:37	Edit Del
ALTER_DATABASE.7	5.71 KB	-rw-r--r--	2021-11-08 22:28:37	Edit Del
ALTER_DEFAULT_PRIVILEGES.7	7.07 KB	-rw-r--r--	2021-11-08 22:28:37	Edit Del
ALTER_DOMAIN.7	7.71 KB	-rw-r--r--	2021-11-08 22:28:37	Edit Del
ALTER_EVENT_TRIGGER.7	2.43 KB	-rw-r--r--	2021-11-08 22:28:37	Edit Del
ALTER_EXTENSION.7	6.9 KB	-rw-r--r--	2021-11-08 22:28:37	Edit Del
ALTER_FOREIGN_DATA_WRAPPER.7	4.57 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_FOREIGN_TABLE.7	12.8 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_FUNCTION.7	8.26 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_GROUP.7	3.09 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_INDEX.7	5.6 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_LANGUAGE.7	2.1 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_LARGE_OBJECT.7	2.15 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_MATERIALIZED_VIEW.7	4.67 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_OPERATOR.7	3.68 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_OPERATOR_CLASS.7	2.86 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_OPERATOR_FAMILY.7	9.13 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_POLICY.7	2.88 KB	-rw-r--r--	2021-11-08 22:28:38	Edit Del
ALTER_ROLE.7	9.09 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_RULE.7	2.21 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_SCHEMA.7	2.32 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_SEQUENCE.7	7.53 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_SERVER.7	3.41 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_SYSTEM.7	3.8 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_TABLE.7	36.51 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_TABLESPACE.7	3.35 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_TEXT_SEARCH_CONFIGURATION.7	4.79 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_TEXT_SEARCH_DICTIONARY.7	4.02 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_TEXT_SEARCH_PARSER.7	2.23 KB	-rw-r--r--	2021-11-08 22:28:39	Edit Del
ALTER_TEXT_SEARCH_TEMPLATE.7	2.27 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
ALTER_TRIGGER.7	2.99 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
ALTER_TYPE.7	7.16 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
ALTER_USER.7	2.66 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
ALTER_USER_MAPPING.7	3.27 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
ALTER_VIEW.7	4.67 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
ANALYZE.7	8.08 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
BEGIN.7	4.07 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
CHECKPOINT.7	2.29 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
CLOSE.7	2.72 KB	-rw-r--r--	2021-11-08 22:28:40	Edit Del
CLUSTER.7	6.24 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
COMMENT.7	10.2 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
COMMIT.7	2.1 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
COMMIT_PREPARED.7	2.58 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
COPY.7	30.19 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
CREATE_ACCESS_METHOD.7	2.9 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
CREATE_AGGREGATE.7	23.36 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
CREATE_CAST.7	13.55 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
CREATE_COLLATION.7	3.97 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
CREATE_CONVERSION.7	3.79 KB	-rw-r--r--	2021-11-08 22:28:41	Edit Del
CREATE_DATABASE.7	8.54 KB	-rw-r--r--	2021-11-08 22:28:42	Edit Del
CREATE_DOMAIN.7	7.54 KB	-rw-r--r--	2021-11-08 22:28:42	Edit Del
CREATE_EVENT_TRIGGER.7	3.75 KB	-rw-r--r--	2021-11-08 22:28:42	Edit Del
CREATE_EXTENSION.7	8.1 KB	-rw-r--r--	2021-11-08 22:28:42	Edit Del
CREATE_FOREIGN_DATA_WRAPPER.7	4.96 KB	-rw-r--r--	2021-11-08 22:28:42	Edit Del
CREATE_FOREIGN_TABLE.7	9 KB	-rw-r--r--	2021-11-08 22:28:42	Edit Del
CREATE_FUNCTION.7	24.95 KB	-rw-r--r--	2021-11-08 22:28:43	Edit Del
CREATE_GROUP.7	2.21 KB	-rw-r--r--	2021-11-08 22:28:43	Edit Del
CREATE_INDEX.7	20.16 KB	-rw-r--r--	2021-11-08 22:28:43	Edit Del
CREATE_LANGUAGE.7	9.83 KB	-rw-r--r--	2021-11-08 22:28:43	Edit Del
CREATE_MATERIALIZED_VIEW.7	4.21 KB	-rw-r--r--	2021-11-08 22:28:43	Edit Del
CREATE_OPERATOR.7	7.12 KB	-rw-r--r--	2021-11-08 22:28:43	Edit Del
CREATE_OPERATOR_CLASS.7	8.52 KB	-rw-r--r--	2021-11-08 22:28:44	Edit Del
CREATE_OPERATOR_FAMILY.7	3.6 KB	-rw-r--r--	2021-11-08 22:28:44	Edit Del
CREATE_POLICY.7	15.92 KB	-rw-r--r--	2021-11-08 22:28:44	Edit Del
CREATE_ROLE.7	12.87 KB	-rw-r--r--	2021-11-08 22:28:44	Edit Del
CREATE_RULE.7	8.63 KB	-rw-r--r--	2021-11-08 22:28:44	Edit Del
CREATE_SCHEMA.7	6.16 KB	-rw-r--r--	2021-11-08 22:28:44	Edit Del
CREATE_SEQUENCE.7	9.79 KB	-rw-r--r--	2021-11-08 22:28:44	Edit Del
CREATE_SERVER.7	3.63 KB	-rw-r--r--	2021-11-08 22:28:44	Edit Del
CREATE_TABLE.7	42.43 KB	-rw-r--r--	2021-11-08 22:28:45	Edit Del
CREATE_TABLESPACE.7	4.47 KB	-rw-r--r--	2021-11-08 22:28:45	Edit Del
CREATE_TABLE_AS.7	7.8 KB	-rw-r--r--	2021-11-08 22:28:45	Edit Del
CREATE_TEXT_SEARCH_CONFIGURATION.7	3.2 KB	-rw-r--r--	2021-11-08 22:28:45	Edit Del
CREATE_TEXT_SEARCH_DICTIONARY.7	3.35 KB	-rw-r--r--	2021-11-08 22:28:45	Edit Del
CREATE_TEXT_SEARCH_PARSER.7	3.57 KB	-rw-r--r--	2021-11-08 22:28:45	Edit Del
CREATE_TEXT_SEARCH_TEMPLATE.7	3.39 KB	-rw-r--r--	2021-11-08 22:28:45	Edit Del
CREATE_TRANSFORM.7	5.8 KB	-rw-r--r--	2021-11-08 22:28:46	Edit Del
CREATE_TRIGGER.7	16.51 KB	-rw-r--r--	2021-11-08 22:28:46	Edit Del
CREATE_TYPE.7	29.13 KB	-rw-r--r--	2021-11-08 22:28:46	Edit Del
CREATE_USER.7	2.45 KB	-rw-r--r--	2021-11-08 22:28:46	Edit Del
CREATE_USER_MAPPING.7	3.27 KB	-rw-r--r--	2021-11-08 22:28:46	Edit Del
CREATE_VIEW.7	14.63 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DEALLOCATE.7	1.99 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DECLARE.7	10.29 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DELETE.7	7.39 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DISCARD.7	2.82 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DO.7	3.08 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DROP_ACCESS_METHOD.7	2.35 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DROP_AGGREGATE.7	3.81 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DROP_CAST.7	2.26 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DROP_COLLATION.7	2.43 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DROP_CONVERSION.7	2.37 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DROP_DATABASE.7	2.38 KB	-rw-r--r--	2021-11-08 22:28:47	Edit Del
DROP_DOMAIN.7	2.34 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_EVENT_TRIGGER.7	2.39 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_EXTENSION.7	2.73 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_FOREIGN_DATA_WRAPPER.7	2.61 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_FOREIGN_TABLE.7	2.59 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_FUNCTION.7	3.36 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_GROUP.7	1.57 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_INDEX.7	3.24 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_LANGUAGE.7	2.86 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_MATERIALIZED_VIEW.7	2.64 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_OPERATOR.7	3.01 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_OPERATOR_CLASS.7	3.48 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_OPERATOR_FAMILY.7	3.24 KB	-rw-r--r--	2021-11-08 22:28:48	Edit Del
DROP_OWNED.7	3.14 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_POLICY.7	2.54 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_ROLE.7	3.06 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_RULE.7	2.36 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_SCHEMA.7	2.76 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_SEQUENCE.7	2.47 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_SERVER.7	2.39 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_TABLE.7	2.97 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_TABLESPACE.7	2.48 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_TEXT_SEARCH_CONFIGURATION.7	2.84 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_TEXT_SEARCH_DICTIONARY.7	2.75 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_TEXT_SEARCH_PARSER.7	2.66 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_TEXT_SEARCH_TEMPLATE.7	2.69 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_TRANSFORM.7	2.6 KB	-rw-r--r--	2021-11-08 22:28:49	Edit Del
DROP_TRIGGER.7	2.61 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
DROP_TYPE.7	2.53 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
DROP_USER.7	1.65 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
DROP_USER_MAPPING.7	2.56 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
DROP_VIEW.7	2.43 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
END.7	2.19 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
EXECUTE.7	2.91 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
EXPLAIN.7	13.03 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
FETCH.7	8.49 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
GRANT.7	21.79 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
IMPORT_FOREIGN_SCHEMA.7	3.99 KB	-rw-r--r--	2021-11-08 22:28:50	Edit Del
INSERT.7	19.61 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
LISTEN.7	3.51 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
LOAD.7	2.54 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
LOCK.7	8.01 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
MOVE.7	2.93 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
NOTIFY.7	8.21 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
PREPARE.7	8.22 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
PREPARE_TRANSACTION.7	5.74 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
REASSIGN_OWNED.7	3.1 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
REFRESH_MATERIALIZED_VIEW.7	3.99 KB	-rw-r--r--	2021-11-08 22:28:51	Edit Del
REINDEX.7	7.71 KB	-rw-r--r--	2021-11-08 22:28:52	Edit Del
RELEASE_SAVEPOINT.7	3.01 KB	-rw-r--r--	2021-11-08 22:28:52	Edit Del
RESET.7	2.93 KB	-rw-r--r--	2021-11-08 22:28:52	Edit Del
REVOKE.7	10.6 KB	-rw-r--r--	2021-11-08 22:28:52	Edit Del
ROLLBACK.7	2.09 KB	-rw-r--r--	2021-11-08 22:28:52	Edit Del
ROLLBACK_PREPARED.7	2.6 KB	-rw-r--r--	2021-11-08 22:28:52	Edit Del
ROLLBACK_TO_SAVEPOINT.7	3.94 KB	-rw-r--r--	2021-11-08 22:28:52	Edit Del
SAVEPOINT.7	3.5 KB	-rw-r--r--	2021-11-08 22:28:52	Edit Del
SECURITY_LABEL.7	5.39 KB	-rw-r--r--	2021-11-08 22:28:52	Edit Del
SELECT.7	63.7 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
SELECT_INTO.7	4.36 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
SET.7	7.58 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
SET_CONSTRAINTS.7	4.48 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
SET_ROLE.7	4.66 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
SET_SESSION_AUTHORIZATION.7	3.88 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
SET_TRANSACTION.7	8.71 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
SHOW.7	4.22 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
START_TRANSACTION.7	2.9 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
TABLE.7	18 B	-rw-r--r--	2021-11-08 22:28:53	Edit Del
TRUNCATE.7	6.39 KB	-rw-r--r--	2021-11-08 22:28:53	Edit Del
UNLISTEN.7	2.75 KB	-rw-r--r--	2021-11-08 22:28:54	Edit Del
UPDATE.7	12.28 KB	-rw-r--r--	2021-11-08 22:28:54	Edit Del
VACUUM.7	7.94 KB	-rw-r--r--	2021-11-08 22:28:54	Edit Del
VALUES.7	6.95 KB	-rw-r--r--	2021-11-08 22:28:54	Edit Del
WITH.7	18 B	-rw-r--r--	2021-11-08 22:28:53	Edit Del

Editing: ALTER_DEFAULT_PRIVILEGES.7 (7.07 KB)

'\" t
.\"     Title: ALTER DEFAULT PRIVILEGES
.\"    Author: The PostgreSQL Global Development Group
.\" Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
.\"      Date: 2021
.\"    Manual: PostgreSQL 9.6.24 Documentation
.\"    Source: PostgreSQL 9.6.24
.\"  Language: English
.\"
.TH "ALTER DEFAULT PRIVILEGES" "7" "2021" "PostgreSQL 9.6.24" "PostgreSQL 9.6.24 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"
ALTER_DEFAULT_PRIVILEGES \- define default access privileges
.SH "SYNOPSIS"
.sp
.nf
ALTER DEFAULT PRIVILEGES
    [ FOR { ROLE | USER } \fItarget_role\fR [, \&.\&.\&.] ]
    [ IN SCHEMA \fIschema_name\fR [, \&.\&.\&.] ]
    \fIabbreviated_grant_or_revoke\fR

where \fIabbreviated_grant_or_revoke\fR is one of:

GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
    [, \&.\&.\&.] | ALL [ PRIVILEGES ] }
    ON TABLES
    TO { [ GROUP ] \fIrole_name\fR | PUBLIC } [, \&.\&.\&.] [ WITH GRANT OPTION ]

GRANT { { USAGE | SELECT | UPDATE }
    [, \&.\&.\&.] | ALL [ PRIVILEGES ] }
    ON SEQUENCES
    TO { [ GROUP ] \fIrole_name\fR | PUBLIC } [, \&.\&.\&.] [ WITH GRANT OPTION ]

GRANT { EXECUTE | ALL [ PRIVILEGES ] }
    ON FUNCTIONS
    TO { [ GROUP ] \fIrole_name\fR | PUBLIC } [, \&.\&.\&.] [ WITH GRANT OPTION ]

GRANT { USAGE | ALL [ PRIVILEGES ] }
    ON TYPES
    TO { [ GROUP ] \fIrole_name\fR | PUBLIC } [, \&.\&.\&.] [ WITH GRANT OPTION ]

REVOKE [ GRANT OPTION FOR ]
    { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
    [, \&.\&.\&.] | ALL [ PRIVILEGES ] }
    ON TABLES
    FROM { [ GROUP ] \fIrole_name\fR | PUBLIC } [, \&.\&.\&.]
    [ CASCADE | RESTRICT ]

REVOKE [ GRANT OPTION FOR ]
    { { USAGE | SELECT | UPDATE }
    [, \&.\&.\&.] | ALL [ PRIVILEGES ] }
    ON SEQUENCES
    FROM { [ GROUP ] \fIrole_name\fR | PUBLIC } [, \&.\&.\&.]
    [ CASCADE | RESTRICT ]

REVOKE [ GRANT OPTION FOR ]
    { EXECUTE | ALL [ PRIVILEGES ] }
    ON FUNCTIONS
    FROM { [ GROUP ] \fIrole_name\fR | PUBLIC } [, \&.\&.\&.]
    [ CASCADE | RESTRICT ]

REVOKE [ GRANT OPTION FOR ]
    { USAGE | ALL [ PRIVILEGES ] }
    ON TYPES
    FROM { [ GROUP ] \fIrole_name\fR | PUBLIC } [, \&.\&.\&.]
    [ CASCADE | RESTRICT ]
.fi
.SH "DESCRIPTION"
.PP
\fBALTER DEFAULT PRIVILEGES\fR
allows you to set the privileges that will be applied to objects created in the future\&. (It does not affect privileges assigned to already\-existing objects\&.) Currently, only the privileges for tables (including views and foreign tables), sequences, functions, and types (including domains) can be altered\&.
.PP
You can change default privileges only for objects that will be created by yourself or by roles that you are a member of\&. The privileges can be set globally (i\&.e\&., for all objects created in the current database), or just for objects created in specified schemas\&.
.PP
As explained under
\fBGRANT\fR(7), the default privileges for any object type normally grant all grantable permissions to the object owner, and may grant some privileges to
PUBLIC
as well\&. However, this behavior can be changed by altering the global default privileges with
\fBALTER DEFAULT PRIVILEGES\fR\&.
.PP
Default privileges that are specified per\-schema are added to whatever the global default privileges are for the particular object type\&. This means you cannot revoke privileges per\-schema if they are granted globally (either by default, or according to a previous
\fBALTER DEFAULT PRIVILEGES\fR
command that did not specify a schema)\&. Per\-schema
REVOKE
is only useful to reverse the effects of a previous per\-schema
GRANT\&.
.SS "Parameters"
.PP
\fItarget_role\fR
.RS 4
The name of an existing role of which the current role is a member\&. If
FOR ROLE
is omitted, the current role is assumed\&.
.RE
.PP
\fIschema_name\fR
.RS 4
The name of an existing schema\&. If specified, the default privileges are altered for objects later created in that schema\&. If
IN SCHEMA
is omitted, the global default privileges are altered\&.
.RE
.PP
\fIrole_name\fR
.RS 4
The name of an existing role to grant or revoke privileges for\&. This parameter, and all the other parameters in
\fIabbreviated_grant_or_revoke\fR, act as described under
\fBGRANT\fR(7)
or
\fBREVOKE\fR(7), except that one is setting permissions for a whole class of objects rather than specific named objects\&.
.RE
.SH "NOTES"
.PP
Use
\fBpsql\fR(1)\*(Aqs
\fB\eddp\fR
command to obtain information about existing assignments of default privileges\&. The meaning of the privilege values is the same as explained for
\fB\edp\fR
under
\fBGRANT\fR(7)\&.
.PP
If you wish to drop a role for which the default privileges have been altered, it is necessary to reverse the changes in its default privileges or use
\fBDROP OWNED BY\fR
to get rid of the default privileges entry for the role\&.
.SH "EXAMPLES"
.PP
Grant SELECT privilege to everyone for all tables (and views) you subsequently create in schema
myschema, and allow role
webuser
to INSERT into them too:
.sp
.if n \{\
.RS 4
.\}
.nf
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT INSERT ON TABLES TO webuser;
.fi
.if n \{\
.RE
.\}
.PP
Undo the above, so that subsequently\-created tables won\*(Aqt have any more permissions than normal:
.sp
.if n \{\
.RS 4
.\}
.nf
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema REVOKE SELECT ON TABLES FROM PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema REVOKE INSERT ON TABLES FROM webuser;
.fi
.if n \{\
.RE
.\}
.PP
Remove the public EXECUTE permission that is normally granted on functions, for all functions subsequently created by role
admin:
.sp
.if n \{\
.RS 4
.\}
.nf
ALTER DEFAULT PRIVILEGES FOR ROLE admin REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;
.fi
.if n \{\
.RE
.\}
.sp
Note however that you
\fIcannot\fR
accomplish that effect with a command limited to a single schema\&. This command has no effect, unless it is undoing a matching
GRANT:
.sp
.if n \{\
.RS 4
.\}
.nf
ALTER DEFAULT PRIVILEGES IN SCHEMA public REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;
.fi
.if n \{\
.RE
.\}
.sp
That\*(Aqs because per\-schema default privileges can only add privileges to the global setting, not remove privileges granted by it\&.
.SH "COMPATIBILITY"
.PP
There is no
\fBALTER DEFAULT PRIVILEGES\fR
statement in the SQL standard\&.
.SH "SEE ALSO"
\fBGRANT\fR(7), \fBREVOKE\fR(7)