Chapter 3 DBMS Reference Guide

SqlListChildrenQuery

SQL query for listing the members or a group.

Example

In Sybase Adaptive Server Enterprise 12.5:

{GROUP ID, MEMBER}

select 
   g.name, u.name
from 
   [%CATALOG%.]dbo.sysusers u, [%CATALOG%.]dbo.sysusers g
where 
   u.suid > 0 and
   u.gid = g.gid and
   g.gid = g.uid
order by 1

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