IS_MEMBER

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

Syntax

IS_MEMBER(expression varchar) → boolean

• expression: String expression identifying a role in Spice.

Examples

IS_MEMBER example

SELECT IS_MEMBER ('public')
-- True

IS_MEMBER example

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