Categories:

Account & Session DDL

DROP MANAGED ACCOUNT

Removes a managed account, including all objects created in the account, and immediately restricts access to the account. Currently used by data providers to create reader accounts for their consumers. For more details, see Managing Reader Accounts.

See also:

CREATE MANAGED ACCOUNT , SHOW MANAGED ACCOUNTS

Syntax

DROP MANAGED ACCOUNT <name>

Usage Notes

  • This command can be executed by users with the ACCOUNTADMIN role (or a role that has been granted the CREATE ACCOUNT global privilege).

  • This operation can not be undone.

Examples

DROP MANAGED ACCOUNT reader_acct1;

  +------------------------------------+
  | status                             |
  |------------------------------------|
  | READER_ACCT1 successfully dropped. |
  +------------------------------------+