Create Users, Profiles, Groups, and Roles
After the new development installation is running, create the Ingres USERs, PROFILEs, GROUPs, and ROLEs. Depending on the version of Ingres, this may have to be done manually or from within the accessdb utility under "users" in the old installation.
• Use the "SQLscript" option to create an SQL file of users.
• PROFILEs, GROUPs, and ROLEs must be created manually.
• The SQL script will contain users that may already exist in the new installation, for example: ingres, system, or administrator. These users can be removed from the SQL script.
• Do not remove other users from the script without ensuring that the user does not own any database objects (tables, views, and so on) in any of the databases that are to be moved.
Look in the config.dat file (which can be found in the ingres\files directory under the Ingres home directory in the old installation) for lines that may have been included to give users any of the following privileges:
• SERVER_CONTROL
• NET_ADMIN
• MONITOR
• TRUSTED
The lines look like this:
ii.<node>.privileges.user.administrator:
SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
ii.<node>.privileges.user.any_user:
SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
These lines must be included in the config.dat file of the new installation.
Last modified date: 01/30/2023