How to Establish User Access
The process of establishing access to Ingres is as follows:
1. The system administrator defines user accounts in the operating system.
Accounts are needed for local users and for remote users who access the product through a local account.
Note: This step is optional if an installation password is defined, in which case users access Ingres directly, without having to go through a local account.
All accounts can be set up before or after Ingres is installed (except for the installation owner account, which is set up during installation, belongs to the system administrator, and is assigned maximum Ingres privileges to perform all operations).
2. The database administrator defines user objects.
After the accounts are set up, a database administrator or system administrator starts Ingres and defines user objects. Part of the user object definition is a user ID, which corresponds to the user ID used to log on to the operating system.
Typically, the system administrator sets up a user object for the database administrator, who in turn sets up user objects for other users.