The Group category is located in the 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% |