Removes the specified database role from the system.
Tip
In addition to SQL, you can also use other interfaces, such as Snowflake REST APIs, Snowflake Python APIs, and Snowflake CLI. See Alternate interfaces.
CREATE DATABASE ROLE , ALTER DATABASE ROLE , SHOW DATABASE ROLES
DROP DATABASE ROLE [ IF EXISTS ] <name>
Copy
Parameters¶name
Specifies the identifier (i.e. name) for the database role; must be unique in the database in which the role is created.
The identifier must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (e.g. "My object"). Identifiers enclosed in double quotes are also case-sensitive.
If the identifier is not fully qualified (in the form of db_name.database_role_name, the command looks for the database role in the current database for the session.
Dropped database roles cannot be recovered; they must be recreated.
Ownership of any objects owned by the dropped database role is transferred to the role that executes the DROP DATABASE ROLE command. To transfer ownership of each of these objects to a different database role, use GRANT OWNERSHIP … COPY CURRENT GRANTS.
If a database role has a future privilege as a grantor or grantee, the database role can only be dropped by a user with a role that has the MANAGE GRANTS privilege.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
All current and future grants that name the database role as either the grantor or the grantee are removed when the database role is dropped.
Query the GRANTS_TO_ROLES Account Usage view to retrieve the privilege grants that name a specified database role as the grantor or grantee:
SELECT *
FROM snowflake.account_usage.grants_to_roles
WHERE grantee_name = upper('<database_name>.<db_role_name>') OR granted_by = upper('<database_name>.<db_role_name>');
Copy
The following example retrieves the grants where d1.dr1 is the grantor or grantee:
SELECT *
FROM snowflake.account_usage.grants_to_roles
WHERE grantee_name = upper('d1.dr1') OR granted_by = upper('d1.dr1');
Copy
Alternate interfaces¶DROP DATABASE ROLE d1.dr1;Copy
Snowflake REST APIs
Delete a database role endpoint
Snowflake Python APIs
Snowflake CLI
Not supported
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