DROP PACKAGES POLICY

从系统中移除包策略。

语法

DROP PACKAGES POLICY [ IF EXISTS ] <name>

参数

name

指定要弃用的包策略的标识符。如果标识符包含空格或特殊字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。

For more details, see Identifier requirements.

访问控制要求

A role used to execute this operation must have the following privileges at a minimum:

权限对象备注
OWNERSHIP包策略OWNERSHIP is a special privilege on an object that is automatically granted to the role that created the object, but can also be transferred using the [GRANT OWNERSHIP](/sql-reference/sql/grant-ownership) command to a different role by the owning role (or any role with the MANAGE GRANTS privilege).

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

使用说明

  • A packages policy cannot be dropped successfully if it is currently attached to an account. Before executing a DROP statement, to UNSET the packages policy from the account, run ALTER ACCOUNT UNSET PACKAGES POLICY.
  • When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.