A. Upgrading from Ingres 6.4 : How You Upgrade from Ingres 6.4 Using Unload/Reload : Record Database Privileges
 
Share this page                  
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 this upgrade procedure.
2. Run the following SQL to save private database access lists and user database privileges:
sql iidbdb
\script dbaccess.out
select dbname, usrname
from iidbaccess
order by dbname, usrname
\go
\script
\script dbprivs.out
select *
from iidbprivileges
where database_name <> ''
order by database_name,grantee_name
\go
\script
\quit
This procedure creates two files, dbaccess.out and dbprivs.out.