Record Database Privileges
To record database privileges
1. As the installation owner, change directories to the unload directory for iidbdb created in Step 1 of the upgrade procedure.
2. Run the following SQL to save user database privileges:
sql iidbdb
\script dbprivs.out
select *
from iidbprivileges
where database_name <> ''
order by database_name,grantee_name
\go
\script
\quit
The file dbprivs.out is created for future reference.