活动专区

活动公告

上车！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_AUDITING_POLICY_FILTERS系统表记录统一审计相关的过滤策略相关信息，每条记录对应一个设计策略。需要有系统管理员或安全策略管理员权限才可以访问此系统表。<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.2400%;">名称</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.3800%;">类型</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.3600%;">描述</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.2400%;">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.3800%;">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.3600%;">行标识符（隐含属性，必须明确选择）。</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.2400%;">filtertype</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.3800%;">name</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.3600%;">过滤类型。目前值仅为logical_expr。</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.2400%;">labelname</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.3800%;">name</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.3600%;">名称。目前值仅为logical_expr。</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.2400%;">policyoid</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.3800%;">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.3600%;">所属审计策略的oid，对应系统表GS_AUDITING_POLICY中的oid。</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.2400%;">modifydate</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.3800%;">timestamp</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.3600%;">创建或修改的最新时间戳。</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.2400%;">logicaloperator</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.3800%;">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.3600%;">过滤条件的逻辑字符串。</td></tr></tbody></table></figure>

GBase 8c

GS_AUDITING_POLICY_FILTERS系统表介绍

名称	类型	描述
oid	oid	行标识符（隐含属性，必须明确选择）。
filtertype	name	过滤类型。目前值仅为logical_expr。
labelname	name	名称。目前值仅为logical_expr。
policyoid	oid	所属审计策略的oid，对应系统表GS_AUDITING_POLICY中的oid。
modifydate	timestamp	创建或修改的最新时间戳。
logicaloperator	text	过滤条件的逻辑字符串。

GS_AUDITING_POLICY_FILTERS系统表介绍

热门帖子