UserIDM

Part-key that uniquely identifies a CA DataMinder user.

Yes

INTEGER

4

None

UserID

Part-key that uniquely identifies a CA DataMinder user.

Yes

INTEGER

4

UserName

The name of the CA DataMinder user. The naming convention (if any) depends on the user creation policy settings.

VARCHAR

64

There may be only one active (non-deleted) user with this user name at any one time.

PolicyIDM

Part-key identifying the policy document for this user.

INTEGER

4

Foreign key: WgnPolicy

PolicyID

Part-key identifying the policy document for this user.

INTEGER

4

Foreign key: WgnPolicy

UserCreateTime

The time that the CA DataMinder user was created.

TIMESTAMP

8

UserRole

The CA DataMinder role assigned to the user. This is used to determine the user's initial privileges.

INTEGER

4

Follow the hyperlink for details.

DeletedFlag

Indicates whether the user account is deleted or not.

BIT

1

UserData

Salt used to hash the password.

VARBINARY

255

PasswordHash

A hashed copy of the users password.

VARBINARY

255

UserPrivileges

A bitmap of CA DataMinder privileges the user is allowed to perform. The initial value is taken from the 'privilege profile' associated with the user's role.

DECIMAL

13

Follow the hyperlink for details.