RetroSearch Browse

Showing content from https://docs.snowflake.com/en/sql-reference/sql/drop-application-role below:

DROP APPLICATION ROLE¶

Removes the specified application role from the system.

See also:: CREATE APPLICATION ROLE , ALTER APPLICATION ROLE , SHOW APPLICATION ROLES

Syntax¶

DROP APPLICATION ROLE [ IF EXISTS ] <name>

Copy

Parameters¶

name: Specifies the identifier for the application role to drop. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Usage notes¶

This command can only be run within the context of an application created using the Native App Framework.
Dropped application roles cannot be recovered; they must be recreated within the application.
Application roles are not versioned. When dropping an application role from a setup script, you must ensure that no running version of the application relies upon the role being dropped. Snowflake recommends to either avoid dropping application roles that may be in use or to wait until the version that depends on the role being dropped has been itself also been dropped.

When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.

Examples¶

DROP APPLICATION ROLE APP_ROLE;

Copy

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4