Categories:

Context functions (Session Object)

CURRENT_ROLE_TYPE

Returns either ROLE or DATABASE_ROLE based on whether the current active role in the session is an account role or a database role, respectively.

Syntax

CURRENT_ROLE_TYPE()
Copy

Arguments

None.

Usage notes

None.

Examples

SELECT CURRENT_ROLE_TYPE();

+---------------------+
| CURRENT_ROLE_TYPE() |
|---------------------|
| ROLE                |
+---------------------+
Copy