ALTER APPLICATION ... { APPROVE | DECLINE} SPECIFICATION¶

根据指定的序列号批准或拒绝一个应用程序规范。

另请参阅：: ALTER APPLICATION SET SPECIFICATIONS、ALTER APPLICATION DROP SPECIFICATION

语法¶

ALTER APPLICATION <app_name>
  { APPROVE | DECLINE } SPECIFICATION <spec_name>
  SEQUENCE_NUMBER = <sequence_num>;

Copy

app_name: 指定要更改的应用程序的标识符。如果标识符包含空格、特殊字符或大小写混合字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。
APPROVE | DECLINE SPECIFICATION spec_name: 批准或拒绝指定的应用程序规范。
SEQUENCE_NUMBER = sequence_num: 指定要批准的应用程序规范的序列号。序列号代表应用程序规范的版本 ID。创建规范时，序号从 1 开始。每次提供商更新应用程序规范时，该值都会递增。使用 SHOW SPECIFICATIONS 或 DESCRIBE SPECIFICATION 命令来确定应用程序的当前序列号。

权限	对象	备注
MANAGE APPLICATION SPECIFICATIONS	账户	Allows a role to approve or decline app specifications for any app in their account. Only the SECURITYADMIN and ACCOUNTADMIN system roles have the MANAGE APPLICATION SPECIFICATIONS privilege; however, the privilege can be granted to custom roles.