Prev | SQL Engine Reference | Next |
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:
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.
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 NoIndex 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.
Prev X$Proc |
Contents Up Check for Revisions | Next X$Rights |