Chapter 3 DBMS Reference Guide


Common entries for Role

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
{ROLE}

select 
   u.name
from 
   master.dbo.syssrvroles u
order by 1
SqlAttrQuery
Drop
drop role %ROLE% [with override]
Create
create role %ROLE% [with passwd "%PASSWORD%"]
[%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.