Try Opteryx

SHOW USER

The SHOW USER statement returns identity details for the current connection — billing account and workspace memberships.

Syntax

sql
SHOW USER;

Result Columns

Column Description
attribute billing_account or membership (one row per membership)
value The attribute's value
type Value's data type

Examples

Show the Current Connection's Identity

sql
SHOW USER;

Notes

  • Returns one membership row per workspace the caller belongs to, plus one billing_account row.

See Also