There is one row in the SYSGROUPS view for each member of each group. This view describes the many-to-many relationship between groups and members. A group may have many members, and a user may be a member of many groups.
The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.
ALTER VIEW "SYS"."SYSGROUPS"( group_name, member_name ) as select g.user_name,u.user_name from SYS.ISYSGROUP, SYS.ISYSUSER as g, SYS.ISYSUSER as u where ISYSGROUP.group_id = g.user_id and ISYSGROUP.group_member = u.user_id; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |