DATABASE_USERS table

The DATABASE_USERS table represents all users known to the system. If a user is an owner, grantor, or grantee, then a row for that user exists in DATABASE_USERS. The primary key is the USERID column. The table has a unique index, DB_USER_BY_NAME, on the GUARDIAN_USER_NAME column.

Column number

Column Name

Data Type

Description

1*

USERID

INT

The Guardian user ID. A known user to the system as grantor, grantee, or owner.

-1 if the user is PUBLIC.

-2 if the user is SYSTEM.

2

GUARDIAN_USER_NAME

CHAR(32)

The Guardian username. Also contains special users PUBLIC and SYSTEM.

* Indicates primary key