加入 Gitee

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

克隆/下载

GS_WLM_USER_INFO.md 11.30 KB

# GS\_WLM\_USER\_INFO<a name="ZH-CN_TOPIC_0289901012"></a>

用户统计信息视图。

**表 1**  GS\_WLM\_USER\_INFO字段

<a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_table209941143164711"></a>
<table><thead align="left"><tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row111151544114711"><th class="cellrowborder" valign="top" width="32%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p111153445476"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p111153445476"></a>名称
</th>
<th class="cellrowborder" valign="top" width="30%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1511554494716"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1511554494716"></a>类型
</th>
<th class="cellrowborder" valign="top" width="38%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p5115134434715"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p5115134434715"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row1211524484715"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p2011517445475"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p2011517445475"></a>userid
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p71155447476"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p71155447476"></a>oid
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p10856165215471"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p10856165215471"></a>用户OID。
</td>
</tr>
<tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row511514419475"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1511544444719"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1511544444719"></a>username
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p311574418476"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p311574418476"></a>name
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1851145234716"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1851145234716"></a>用户名。
</td>
</tr>
<tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row1111594494711"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1711534410471"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1711534410471"></a>sysadmin
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p11115114424710"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p11115114424710"></a>boolean
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p5844165254714"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p5844165254714"></a>是否是管理员用户。
</td>
</tr>
<tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row011513449472"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p6115154494720"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p6115154494720"></a>rpoid
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p14115194419479"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p14115194419479"></a>oid
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p9839115264713"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p9839115264713"></a>关联的资源池的OID。
</td>
</tr>
<tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row21157446479"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1011524411476"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1011524411476"></a>respool
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p121151544164711"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p121151544164711"></a>name
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p68351052114717"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p68351052114717"></a>关联的资源池的名称。
</td>
</tr>
<tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row3115134410478"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p4115944154720"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p4115944154720"></a>parentid
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p511514412471"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p511514412471"></a>oid
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p983125216475"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p983125216475"></a>用户组的OID。
</td>
</tr>
<tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row7115174494719"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p121151844124712"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p121151844124712"></a>totalspace
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p0117174417471"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p0117174417471"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p582535294717"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p582535294717"></a>用户的可用空间上限。
</td>
</tr>
<tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row535383020518"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p103541230255"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p103541230255"></a>spacelimit
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p03551307511"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p03551307511"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p58211652174714"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p58211652174714"></a>用户表空间限制。
</td>
</tr>
<tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row41171644194713"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p18117134474714"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p18117134474714"></a>childcount
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p811718441478"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p811718441478"></a>interger
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p108168522478"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p108168522478"></a>子用户的个数。
</td>
</tr>
<tr id="zh-cn_topic_0283137453_zh-cn_topic_0237122399_row1211724474714"><td class="cellrowborder" valign="top" width="32%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1811754434718"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1811754434718"></a>childlist
</td>
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1511710441476"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p1511710441476"></a>text
</td>
<td class="cellrowborder" valign="top" width="38%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p18812125204710"></a><a name="zh-cn_topic_0283137453_zh-cn_topic_0237122399_p18812125204710"></a>子用户列表。
</td>
</tr>
</tbody>
</table>

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

提交于 2021-09-14 16:53 . add feature

GS_WLM_USER_INFO

用户统计信息视图。

表 1 GS_WLM_USER_INFO字段

名称	类型	描述
userid	oid	用户OID。
username	name	用户名。
sysadmin	boolean	是否是管理员用户。
rpoid	oid	关联的资源池的OID。
respool	name	关联的资源池的名称。
parentid	oid	用户组的OID。
totalspace	bigint	用户的可用空间上限。
spacelimit	bigint	用户表空间限制。
childcount	interger	子用户的个数。
childlist	text	子用户列表。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

3.0.0

openGauss / docs

GS_WLM_USER_INFO

简介

发行版

贡献者

近期动态

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

GS_WLM_USER_INFO

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs