USERXUSERGROUP - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 23.1
License

The USERXUSERGROUP table stores the relationship between an OnBase user and the user groups to which that user belongs. A user can belong to multiple user groups, and any user group can have multiple users. The USERXUSERGROUP table is located in DBSpace8.

USERXUSERGROUP table values
Column Name Data Type Description
usernum bigint The unique identifier for each OnBase user (crossreferenced to USERACCOUNT).
usergroupnum bigint The unique identifier for each OnBase user group (crossreferenced to USERGROUP).
cfgrightdefault bigint  

The index for the USERXUSERGROUP table is located in DBSpace8.

USERXUSERGROUP index
Index Name Included Columns
userxusergroup1 usernum, usergroupnum