ALTER APPLICATION … { APPROVE | DECLINE} SPECIFICATION

Approves or declines an app specification using the specified sequence number.

See also:

ALTER APPLICATION SET SPECIFICATION, ALTER APPLICATION DROP SPECIFICATION

语法

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

参数

app_name

指定要更改的应用程序的标识符。如果标识符包含空格、特殊字符或大小写混合字符,则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。

{ APPROVE | DECLINE } SPECIFICATION spec_name

批准或拒绝指定的应用程序规范。

SEQUENCE_NUMBER = sequence_num

Specifies the sequence number of the app specification to approve. The sequence number represents a version id of the app specification. The sequence number starts at 1 when the specification is created. The value is incremented each time the provider updates the app specification. Use SHOW SPECIFICATIONS or DESCRIBE SPECIFICATION commands to determine the current sequence number of the app.

访问控制要求

权限对象备注
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.