Recreate Database Privileges
To recreate database privileges:
1. As the installation owner, change to the iidbdb unloaddb directory.
2. Refer to the file dbprivs.out created in the step Record Database Privileges.
Each row in the dbprivs.out file describes one or more database privileges given to the user grantee-name. A Y or N in a privilege column indicates the specific privilege. (A U in a column means “Unchanged.”)
3. Start an iidbdb Terminal Monitor session:
sql iidbdb
4. For each row, issue the statement:
grant privilege on database database-name to grantee-name;commit
If the privilege column is N, grant noprivilege instead of privilege.
5. When finished, use \quit to exit the iidbdb session.
The structure of the iidbpriv catalog did not change between OpenIngres 1.x and Ingres 2.6, so it is possible to copy the original contents of the catalog directly. However, we do not recommend this because the catalog may change in future releases.
If you have defined many privileges, or recreated many users, groups, or roles, you should run sysmod on the iidbdb, which will accelerate query processing. Issue the sysmod command, as follows:
sysmod iidbdb