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
create table unload_tmp as
select name,status,default_group
from iiuser
where name not in ('ingres','$ingres','root')
\go
copy unload_tmp (
name=c0comma,status=c0comma,default_group=c0nl
) into 'users.out'
\go
drop unload_tmp;commit
\go
copy iiusergroup (
groupid=c0comma,groupmem=c0nl
) into 'groups.out'
\go
copy iirole(
roleid=c0nl
) into 'roles.out'
\go
\quit