sysattributes

Table 11-1 shows the representation of temporary database groups and bindings as these appear in the sysattributes system table. Only relevant columns are shown. All other columns are NULL. Groups are represented in rows where attribute has a value of “0”. Login and application bindings, as well as database to group bindings, are represented in rows where attribute has a value of “1”.

Table 11-1: sysattributes representation

class

attribute

object_type

object_cinfo

object

object_cinfo1

int_value

char_value

16

0

GR

group name

NULL

NULL

group id

NULL

16

0

D

database name

group ID

NULL

NULL

NULL

16

1

LG

NULL

user ID

0 for soft, 1 for hard

0 for database, 1 for group

database or group name

16

1

AP

application name

NULL

0 for soft, 1 for hard

0 for database, 1 for group

database or group name