Chapter 3 DBMS Reference Guide
You can define values for the following common entries for the Group object in the DBMS definition.
| Entry | Example (Sybase ASE 12.5) |
|---|---|
| Enable | Enable = Yes |
| SqlListQuery |
{GROUP}
select
u.name
from
[%CATALOG%.]dbo.sysusers u
where
u.uid = u.gid and
u.gid not in (select r.lrid from [%CATALOG%.]dbo.sysroles r)
order by 1
|
| SqlAttrQuery |
— |
| Drop |
sp_dropgroup %GROUP% |
| Create |
sp_addgroup %GROUP% [%BIND%] [%PRIVILEGE%] |
| Maxlen |
— |
| ModifiableAttributes | List of extended attributes that will be taken into account in the merge dialog box during database synchronization |
| ReversedStatements | List of statements that will be reverse engineered |
For a description of each of the common object entries, see section "Common object entries".
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |