CODEWITHSUNDEEP
snowflake-cloud-data-platform
Jonito
Jonito

Reputation: 459

Snowflake issue when drop users

As Snowflake documentation, I need ownership and rights to drop any object.

So someone created a user account using accountadmin role (owner of the account). When I try to delete it or transfer ownership using owner role, I can't.

Where am I wrong?

USE ROLE ACCOUNTADMIN;

DROP USER "[email protected]";

User '"[email protected]" ' does not exist or not authorized.

If I perform some tests with the same account :

USE ROLE ACCOUNTADMIN;

CREATE USER "[email protected]";

User with login name '[email protected]' already exists.

If I try to create and delete users with this account...

USE ROLE ACCOUNTADMIN;

CREATE USER "[email protected]";

User [email protected] successfully created.

DROP USER "[email protected]";

[email protected] successfully dropped.

Upvotes: 0

Views: 1047

Answers (2)

Jonito
Jonito

Reputation: 459

I have been able to drop users after this command:

ALTER SESSION UNSET QUOTED_IDENTIFIERS_IGNORE_CASE;

Upvotes: 2

Mike Walton
Mike Walton

Reputation: 7339

Most likely the ACCOUNTADMIN doesn't own the user. I believe that only the owner can DROP. Run:

SHOW USERS LIKE '[email protected]'

This will show you what role owns the user. Use that role to drop the user.

Upvotes: 0

Related Questions