X$User

---

The X$User system table is associated with the file USER.DDF. X$User contains the name and password of each user and the name of each user group. Pervasive.SQL uses this table only when you enable the security option. The structure of X$User is as follows:

 
Table C-15 X$User System Table Structure

Column Name	Type	Size	Case Insensitive	Description
Xu$Id	USMALLINT	2	N/A	Internal ID assigned to the user or group.
Xu$Name	CHAR	30	Yes	User or group name.
Xu$Password	CHAR	9	No	User password (encrypted)
Xu$Flags	USMALLINT	2	N/A	User or group flags.

---

Note
For any row in the X$User system table that describes a group, the column value for Xu$Password is NULL.

---

The Xu$Flags column contains integer values whose rightmost 8 bits define the user or group attributes. The following table describes how Pervasive.SQL interprets each bit position when the bit has the binary value of 1. Bit position 0 is the rightmost bit in the integer.

 
Table C-16 Xu$Flags System Table Bit Position Definitions

Bit Position	Decimal Equivalent	Description
0	1	Reserved.
1	2	Reserved.
2	4	Reserved.
3	8	Reserved.
4	16	Reserved.
5	32	Reserved.
6	64	Name is a group name.
7	128	User or group has the right to define tables in the dictionary.

The value in the Xu$Flags column for a particular user or group is the sum of the decimal values corresponding to the attributes that apply to the user or group.

Two indexes are defined for the X$User table, as follows:

 
Table C-17 X$User System Table Index Definitions

Index Number	Segment Number	Column Name	Duplicates	Case Insensitive	Segmented
0	0	Xu$Id	Yes	N/A	No
1	0	Xu$Name	No	Yes	No

Index Number corresponds to the value stored in the Xi$Number column in the X$Index system table. Segment Number corresponds to the value stored in the Xi$Part column in the X$Index system table.