REVOKE APPLICATION ROLE¶

Revokes an application role from an account role or another application role.

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

Syntax¶

REVOKE APPLICATION ROLE <name> FROM { ROLE <parent_role_name> | APPLICATION ROLE <application_role> | APPLICATION <application> }

Copy

Parameters¶

name: Specifies the identifier for the application role to revoke. 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.
FROM ROLE parent_role_name: Revokes the application role from the specified account role.
APPLICATION ROLE application_role: Revokes the role from the specified application role.
APPLICATION ROLE application: Revokes the role from the specified application.

Usage notes¶

An application role may only be revoked from another application role within the context of the installed application, for example within the application setup script.

Examples¶

REVOKE APPLICATION ROLE app_role FROM APPLICATION ROLE other_role;

Copy