How You Establish User Access to Tools and Databases
The install process identifies only the owner of the system administrator account to your installation to permit authorized access to the databases.
To enable users to access tools and databases, the system administrator must do the following:
• Edit the user login files to facilitate user access to the tools needed to query the databases.
• Use the accessdb command or CREATE USER statement to authorize users to access specific databases.
• Ensure that the appropriate logical names are “visible” to the users
Facilitate User Access to Tools
To facilitate user access to tools when they log in to the system, add the following access commands to the login.com file for the user:
For users, add:
@II_SYSTEM:[ingres]ingusrdef.com
For database administrators, add:
@II_SYSTEM:[ingres]ingdbadef.com
For the system administrator, add:
@II_SYSTEM:[ingres]ingsysdef.com
The commands in these files provide tools access to all users in a system-level installation and to all users with the appropriate group user identification code (UIC) in a group-level installation.
Last modified date: 11/28/2023