From 311bcfc6b3acdd6fd152798c7f287ddf74fa2a98 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Tue, 16 Apr 2024 21:46:48 +0200 Subject: Adding upstream version 15.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/catalog-pg-default-acl.html | 58 +++++++++++++++++++++++++++ 1 file changed, 58 insertions(+) create mode 100644 doc/src/sgml/html/catalog-pg-default-acl.html (limited to 'doc/src/sgml/html/catalog-pg-default-acl.html') diff --git a/doc/src/sgml/html/catalog-pg-default-acl.html b/doc/src/sgml/html/catalog-pg-default-acl.html new file mode 100644 index 0000000..e123eff --- /dev/null +++ b/doc/src/sgml/html/catalog-pg-default-acl.html @@ -0,0 +1,58 @@ + +53.17. pg_default_acl
53.17. pg_default_acl
Prev UpChapter 53. System CatalogsHome Next

53.17. pg_default_acl

+ The catalog pg_default_acl stores initial + privileges to be assigned to newly created objects. +

Table 53.17. pg_default_acl Columns

+ Column Type +

+

+ Description +

+ oid oid +

+

+ Row identifier +

+ defaclrole oid + (references pg_authid.oid) +

+

+ The OID of the role associated with this entry +

+ defaclnamespace oid + (references pg_namespace.oid) +

+

+ The OID of the namespace associated with this entry, + or zero if none +

+ defaclobjtype char +

+

+ Type of object this entry is for: + r = relation (table, view), + S = sequence, + f = function, + T = type, + n = schema +

+ defaclacl aclitem[] +

+

+ Access privileges that this type of object should have on creation +


+ A pg_default_acl entry shows the initial privileges to + be assigned to an object belonging to the indicated user. There are + currently two types of entry: “global” entries with + defaclnamespace = zero, and “per-schema” entries + that reference a particular schema. If a global entry is present then + it overrides the normal hard-wired default privileges + for the object type. A per-schema entry, if present, represents privileges + to be added to the global or hard-wired default privileges. +

+ Note that when an ACL entry in another catalog is null, it is taken + to represent the hard-wired default privileges for its object, + not whatever might be in pg_default_acl + at the moment. pg_default_acl is only consulted during + object creation. +

Prev Up Next
53.16. pg_db_role_setting Home 53.18. pg_depend
\ No newline at end of file -- cgit v1.2.3