Save Users, Groups, and Roles
Note: This step is required only for a clean-install upgrade.
To save users, groups,and roles
1. As the installation owner, change directory to the iidbdb unload directory created in Step 1 of the upgrade procedure.
2. Run the following SQL to save users, groups, and roles:
sql iidbdb
copy iiusergroup (groupid=c0comma,groupmem=c0nl) into 'groups.out'
\go
copy iirole(roleid=c0nl) into 'roles.out'
\go
create table role_tmp as select rgr_rolename, rgr_grantee
from iirolegrant;
\go
copy role_tmp( rgr_rolename = c0comma, rgr_grantee = c0nl )
into 'rolegrants.out';
drop role_tmp;
\go
\quit
3. Run accessdb, and select Users, then SQLscript.
A file called users.sql is written that will recreate all users, as they are currently defined.
Note: SQLscript creates users only, and not the profiles, groups, or roles associated with each user. Roles and groups must be unloaded and reloaded for the script to generate the expected results.