Skip to main content
Version: 0.0.1

IS_MEMBER

Categories: Boolean

IS_MEMBER

Returns whether the current user is a member of the specified role.

Syntax​

IS_MEMBER(expression varchar) → boolean​

  • expression: String expression identfying a role in Dremio.

Examples

{{< codeheader "IS_MEMBER example" >}}

SELECT IS_MEMBER ('public')
-- True

{{< codeheader "IS_MEMBER example" >}}

SELECT IS_MEMBER ('non-role')
-- False