The USERGROUP table stores a record for every configured OnBase user group. The USERGROUP table is located in DBSpace8.
| Column Name | Data Type | Description |
|---|---|---|
| usergroupnum | bigint | The unique identifier for each OnBase user group. |
| usergroupname | char(128) | User group name. |
| grouptoemulate | bigint | |
| mfaccessflag | bigint | |
| userprivilege0 | bigint | |
| userprivilege1 | bigint | |
| userprivilege2 | bigint | |
| userprivilege3 | bigint | |
| timeout | bigint | |
| userprivilege4 | bigint | |
| passwordflags | bigint | |
| passwordexpires | bigint | |
| passworddllpath | char(255) | |
| passwordhistdays | bigint | |
| configrights | bigint | |
| timeouttype | bigint | |
| logviewprivs | bigint | |
| logdeleteprivs | bigint | |
| configrights2 | bigint | |
| userprivilege5 | bigint | |
| userprivilege6 | bigint | |
| userprivilege7 | bigint | |
| pswdpolicynum | bigint | |
| pinpolicynum | bigint | |
| controlsettings | bigint | |
| ugaaccess | bigint |
The index for the USERGROUP table is located in DBSpace8.
| Index name | Included Columns |
|---|---|
| usergroup1 | usergroupnum |
| usergroup2 | usergroupnum, usergroupname |
| usergroup3 | ugaaccess, usergroupnum |