加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

PG_DEFAULT_ACL.md 7.34 KB

# PG\_DEFAULT\_ACL<a name="ZH-CN_TOPIC_0242385810"></a>

PG\_DEFAULT\_ACL系统表存储为新建对象设置的初始权限。

**表 1**  PG\_DEFAULT\_ACL字段

<a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_t911a43ec006c402ab1d135f5ee8c89ab"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122283_zh-cn_topic_0059777906_r87bc9f81f24040b18a76384f2d608578"><th class="cellrowborder" valign="top" width="29.720000000000002%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a5f941bcf7b454802b20f0ed2a723e6df"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a5f941bcf7b454802b20f0ed2a723e6df"></a>名称
</th>
<th class="cellrowborder" valign="top" width="16.919999999999998%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_ac05eeed7b9ed4f0e935eb78385d16718"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_ac05eeed7b9ed4f0e935eb78385d16718"></a>类型
</th>
<th class="cellrowborder" valign="top" width="53.36%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_af40f5055b5a84628beb2767172ea6585"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_af40f5055b5a84628beb2767172ea6585"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122283_row9820152919527"><td class="cellrowborder" valign="top" width="29.720000000000002%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122283_p10820132914527"></a><a name="zh-cn_topic_0237122283_p10820132914527"></a>oid
</td>
<td class="cellrowborder" valign="top" width="16.919999999999998%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122283_p11820329155215"></a><a name="zh-cn_topic_0237122283_p11820329155215"></a>oid
</td>
<td class="cellrowborder" valign="top" width="53.36%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122283_p182022935215"></a><a name="zh-cn_topic_0237122283_p182022935215"></a>行标识符（隐藏属性，必须明确选择）。
</td>
</tr>
<tr id="zh-cn_topic_0237122283_zh-cn_topic_0059777906_r621c14f0ad3b4f32a76050a63855c760"><td class="cellrowborder" valign="top" width="29.720000000000002%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a394db9d33c274c88a81003bb704c8d60"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a394db9d33c274c88a81003bb704c8d60"></a>defaclrole
</td>
<td class="cellrowborder" valign="top" width="16.919999999999998%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_ae8f3ce5c5c874992915f6f2831d31af0"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_ae8f3ce5c5c874992915f6f2831d31af0"></a>oid
</td>
<td class="cellrowborder" valign="top" width="53.36%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a138e0e7fc9b3403189f39f7b2a5b6de4"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a138e0e7fc9b3403189f39f7b2a5b6de4"></a>与此权限相关的角色ID。
</td>
</tr>
<tr id="zh-cn_topic_0237122283_zh-cn_topic_0059777906_re736049da33745fdb46dde525f71e7f1"><td class="cellrowborder" valign="top" width="29.720000000000002%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_ac09aa633d0e14a68b0f1a93f851f21aa"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_ac09aa633d0e14a68b0f1a93f851f21aa"></a>defaclnamespace
</td>
<td class="cellrowborder" valign="top" width="16.919999999999998%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a93bea99ea00d458e942c7b6a22dcb1f3"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a93bea99ea00d458e942c7b6a22dcb1f3"></a>oid
</td>
<td class="cellrowborder" valign="top" width="53.36%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a533bd762d129400e9d9125b18fe69d16"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a533bd762d129400e9d9125b18fe69d16"></a>与此权限相关的名称空间，如果没有，则为0。
</td>
</tr>
<tr id="zh-cn_topic_0237122283_zh-cn_topic_0059777906_rcacbb7620ce549638f8ab8c888921237"><td class="cellrowborder" valign="top" width="29.720000000000002%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_ae8564799e7f94d999ac0580ada02a30e"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_ae8564799e7f94d999ac0580ada02a30e"></a>defaclobjtype
</td>
<td class="cellrowborder" valign="top" width="16.919999999999998%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a608df6e47904445ca3b41834f073892a"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a608df6e47904445ca3b41834f073892a"></a>"char"
</td>
<td class="cellrowborder" valign="top" width="53.36%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_aa8458d3ff4ff448a91e6f51f4e901a7a"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_aa8458d3ff4ff448a91e6f51f4e901a7a"></a>此权限的对象类型。
</td>
</tr>
<tr id="zh-cn_topic_0237122283_zh-cn_topic_0059777906_r6389ca9812574d7ea9b2e4c653ab8d98"><td class="cellrowborder" valign="top" width="29.720000000000002%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a1e1a0f9ac0d2401eaba0cfda6a28d508"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a1e1a0f9ac0d2401eaba0cfda6a28d508"></a>defaclacl
</td>
<td class="cellrowborder" valign="top" width="16.919999999999998%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a38cf886ea4514420b6e3b483bdaeb5a8"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a38cf886ea4514420b6e3b483bdaeb5a8"></a>aclitem[]
</td>
<td class="cellrowborder" valign="top" width="53.36%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a2e60ddd9d4be4d088d70e93efe1d3244"></a><a name="zh-cn_topic_0237122283_zh-cn_topic_0059777906_a2e60ddd9d4be4d088d70e93efe1d3244"></a>创建该类型时所拥有的访问权限。
</td>
</tr>
</tbody>
</table>

一键复制编辑原始数据按行查看历史

提交于 2020-05-29 19:27 . Upload openGauss information

PG_DEFAULT_ACL

PG_DEFAULT_ACL系统表存储为新建对象设置的初始权限。

表 1 PG_DEFAULT_ACL字段

名称	类型	描述
oid	oid	行标识符（隐藏属性，必须明确选择）。
defaclrole	oid	与此权限相关的角色ID。
defaclnamespace	oid	与此权限相关的名称空间，如果没有，则为0。
defaclobjtype	"char"	此权限的对象类型。
defaclacl	aclitem[]	创建该类型时所拥有的访问权限。

https://gitee.com/opengauss/docs.git

git@gitee.com:opengauss/docs.git

opengauss

docs

1.1.0

openGauss / docs

PG_DEFAULT_ACL

简介

发行版

贡献者

近期动态

openGauss / docs .gitee-modal { width: 500px !important; }

PG_DEFAULT_ACL

简介

发行版

开源评估指数源自 OSS-Compass 评估体系，评估体系围绕以下三个维度对项目展开评估：

贡献者

近期动态

搜索帮助

openGauss / docs