Chapter 3 DBMS Reference Guide
The Group category is located in the Root→Script→Objects category, and can contain the following items that define how groups are modeled for your DBMS.
| Item | Description |
|---|---|
| [Common items] | The following common object items may be defined for groups:
For a description of each of these common items, see Common object items. |
| Bind | Specifies a command for adding a user to a group.
Example (SQL Anywhere 10): grant membership in group %GROUP% to %USER% |
| Group Comment |
Specifies a statement for adding a group comment. |
| ObjectOwner | Allows groups to be object owners. |
| SqlListChildren Query |
Specifies a SQL query for listing the members of a group.
Example (ASE 15): {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, 2
|
| Unbind | Specifies a command for removing a user from a group.
Example (SQL Anywhere 10): revoke membership in group %GROUP% from %USER% |
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |