UserDetail
- Last UpdatedMar 10, 2025
- 1 minute read
Contains one row for each AVEVA Historian user. Used to store additional user information that is not stored in the Microsoft SQL Server Runtime.sysusers table. Applicable for both users and groups of users.
When AVEVA Historian is installed, a SQL job is created on the Microsoft SQL Server that automatically updates this table every hour. In order for this job to run, the SQL Server Agent must be running. For more information about jobs, see your Microsoft Online Books.
|
Column |
Data Type |
Description |
|---|---|---|
|
(PK) UserKey |
int NOT NULL |
The unique numerical identifier for a database user as defined in the UserDetail table. |
|
UserName |
nvarchar(128) NOT NULL |
The name of the database user. |
|
AccessLevel |
int NOT NULL |
The security level for the user. 1 is the lowest level and 9999 is the highest. Used to limit access of certain users. |
|
uid |
int NOT NULL |
The identifier for the user. This ID is referenced from the Microsoft SQL Server sysusers table. |
|
gid |
int NOT NULL |
The identifier for the group in which a user belongs. This ID is referenced from the Microsoft SQL Server sysusers table. |