Establish User Access to Tools and Databases
The install process identifies only the owner of the system administrator account to your instance to permit authorized access to the databases.
To enable users to access tools and databases and to support shared libraries, the system administrator must do the following:
• Edit the user login files to facilitate user access to the tools needed to query the databases.
• Edit the user login files to set up shared library paths.
Use the accessdb command or CREATE USER statement to authorize users to access specific databases. For more information, see the Ingres Command Reference Guide and the Ingres SQL Reference Guide.
Edit User Login File to Facilitate User Access to Tools
To facilitate user access to Ingres tools when users log in to the system, add the following access commands to the users’ login files, where installation_location is the storage location for your instance’s system files (executables).
For C shell, add the following command to each user’s “.cshrc” file:
% setenv II_SYSTEM installation_location
% set path=($II_SYSTEM/ingres/bin $II_SYSTEM/ingres/utility $path)
For Bourne shell, add the following command to each user’s “.profile” file:
$ II_SYSTEM=installation_location; export II_SYSTEM
$ PATH=$PATH:$II_SYSTEM/ingres/bin:$II_SYSTEM/ingres/utility; export PATH
Edit User Login File to Set Up Shared Library Paths
To support shared libraries on your operating system, include the following command in each user’s path. For the name of the library variable (lib_variable) for your platform—for example, LD_LIBRARY_PATH, LD_LIBRARY_PATH_64, LIBPATH, SHLIB_PATH, or SH_LIB_PATH—see the Readme.
For C shell:
% setenv lib_variable
/lib:$II_SYSTEM/ingres/lib:$lib_variable
For Bourne shell:
$ lib_variable=/lib:$II_SYSTEM/ingres/lib: $lib_variable
$ export lib_variable