活动专区

活动公告

上车！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 常用函数、表达式

GS_DB_PRIVILEGE系统表记录ANY权限的授予情况，每条记录对应一条授权信息。<figure class="table" style="width:99.9600%;"><table style=";"><tbody><tr><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:28.0600%;">名称</td><td style="background-color:rgb(215, 215, 215);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.7600%;">类型</td><td style="background-color:rgb(215, 215, 215);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top:1.0000pt solid windowtext;padding:6.0000pt 9.0000pt;vertical-align:top;width:45.1400%;">描述</td></tr><tr><td style="background-color:rgb(255, 255, 255);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:28.0600%;">oid</td><td style="background-color:rgb(255, 255, 255);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.7600%;">oid</td><td style="background-color:rgb(255, 255, 255);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:45.1400%;">行标识符（隐含字段，必须明确选择）。</td></tr><tr><td style="background-color:rgb(255, 255, 255);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:28.0600%;">roleid</td><td style="background-color:rgb(255, 255, 255);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.7600%;">oid</td><td style="background-color:rgb(255, 255, 255);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:45.1400%;">用户标识。</td></tr><tr><td style="background-color:rgb(255, 255, 255);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:28.0600%;">privilege_type</td><td style="background-color:rgb(255, 255, 255);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.7600%;">text</td><td style="background-color:rgb(255, 255, 255);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:45.1400%;">用户拥有的ANY权限，取值参考GRANT中描述。</td></tr><tr><td style="background-color:rgb(255, 255, 255);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:28.0600%;">admin_option</td><td style="background-color:rgb(255, 255, 255);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:26.7600%;">boolean</td><td style="background-color:rgb(255, 255, 255);border-bottom:1.0000pt solid windowtext;border-left-style:none;border-right:1.0000pt solid windowtext;border-top-style:none;padding:6.0000pt 9.0000pt;vertical-align:top;width:45.1400%;">是否具有privilege_type列记录的ANY权限的再授权权限。t：表示具有。f：表示不具有。</td></tr></tbody></table></figure>

GBase 8c

GS_DB_PRIVILEGE系统表介绍

名称	类型	描述
oid	oid	行标识符（隐含字段，必须明确选择）。
roleid	oid	用户标识。
privilege_type	text	用户拥有的ANY权限，取值参考GRANT中描述。
admin_option	boolean	是否具有privilege_type列记录的ANY权限的再授权权限。 t：表示具有。 f：表示不具有。

GS_DB_PRIVILEGE系统表介绍

热门帖子