Chapter 3 DBMS Reference Guide

SqlListChildrenQuery

SQL query for listing the users to which the role has been assigned.

Example

In Sybase Adaptive Server Enterprise 12.5:

{ ROLE ID, MEMBER }

SELECT 
   r.name, u.name  
FROM 
   master.dbo.sysloginroles l,
   [%CATALOG%.]dbo.sysroles s,
   [%CATALOG%.]dbo.sysusers u,
   [%CATALOG%.]dbo.sysusers r
where 
   l.suid = u.suid
   and s.id     =l.srid
   and r.uid = s.lrid

Copyright (C) 2005. Sybase Inc. All rights reserved.