Group

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:

  • AfterCreate, AfterDrop, AfterModify

  • BeforeCreate, BeforeDrop, BeforeModify

  • Create, Drop

  • Enable

  • Maxlen

  • ModifiableAttributes

  • ReversedQueries, ReversedStatements

  • SqlAttrQuery, SqlListQuery, SqlPermQuery

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%