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>
Copy

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. |
  +------------------------------------+
Copy