Recreate Database Privileges
To recreate database privileges:
1. As the installation owner, change to the iidbdb unloaddb directory.
2. Refer to the file dbaccess.out created in the step Record Database Privileges.
3. Start an iidbdb Terminal Monitor session:
sql iidbdb
4. For each database and user combination listed in dbaccess.out, issue the statement:
grant access on database database-name to username; commit
5. Review the file dbprivs.out created in the step Record Database Privilege.
Each row 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.)
6. 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.
7. When finished, use \quit to exit the iidbdb session.
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