活动专区

活动公告

上车！GBase 8a开发者联盟发车了 技术福利、人脉资源全都有！

认证培训专区

认证培训资料

GBase 8s GDCA 认证培训课前准备

GBase 8a

其他

物化视图报错：references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

01-GBase 8s 事务型数据库 安装与卸载

GBase 8s

适配迁移

[GBase 8s 教程]GBase 8s 常用函数、表达式

PG_SECLABEL系统表存储数据对象上的安全标签。PG_SECLABEL的作用类似，只是它是用于在一个GBase 8c内共享的数据库对象的安全标签上的。<figure class="table" style="width:99.9600%;"><table><tbody><tr><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:14.8000%;">名称</td><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.9200%;">类型</td><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.0400%;">引用</td><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:47.2000%;">描述</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:14.8000%;">objoid</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.9200%;">oid</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.0400%;">任意OID属性</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:47.2000%;">这个安全标签所属的对象的OID。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:14.8000%;">classoid</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.9200%;">oid</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.0400%;">PG_CLASS.oid</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:47.2000%;">出现这个对象的系统目录的OID。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:14.8000%;">objsubid</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.9200%;">integer</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.0400%;">-</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:47.2000%;">出现在这个对象中的列的序号。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:14.8000%;">provider</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.9200%;">text</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.0400%;">-</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:47.2000%;">与这个标签相关的标签提供程序。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:14.8000%;">label</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:11.9200%;">text</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.0400%;">-</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:47.2000%;">应用于这个对象的安全标签。</td></tr></tbody></table></figure>

GBase 8c

PG_SECLABEL系统表介绍

名称	类型	引用	描述
objoid	oid	任意OID属性	这个安全标签所属的对象的OID。
classoid	oid	PG_CLASS.oid	出现这个对象的系统目录的OID。
objsubid	integer	-	出现在这个对象中的列的序号。
provider	text	-	与这个标签相关的标签提供程序。
label	text	-	应用于这个对象的安全标签。

PG_SECLABEL系统表介绍

热门帖子