Redshift – list Role Members

  Kiến thức lập trình

Looking for a list of role-user relationships.

I’ve done it, but cross joining with many function calls doesn’t feel ‘efficient’ to me ?

Does anyone know of a more efficient way ?

select 
u.usename,
r.role_name,
user_is_member_of(u.usename, r.role_name)
from SVV_ROLES r, pg_user u
where user_is_member_of(u.usename, r.role_name) = true

LEAVE A COMMENT