When adding, editing and deleting users while managing different permissions for users, it is always best to perform regular maintenance on the R:BASE SYS_PASSWORDS system table, which stores the password information.
To perform the maintenance, use the PACK PASSWORD command at the R> Prompt or in a command file.
PACK PASSWORD
The command will clean out bogus rows from the system table. This command can be used in a multi-user environment.
All user permissions can be unloaded from the database into a file with the UNLOAD command. The resulting output will only contain the existing GRANT permissions. No user names or password are provided.
OUTPUT UserPriv.str
UNLOAD STRUCTURE FOR ACCESS
OUTPUT SCREEN
All database users, passwords, and user permissions can be unloaded from the database into a file by unloading the entire database structure into a file.
OUTPUT dbname.str
UNLOAD STRUCTURE
OUTPUT SCREEN
The resulting output file will contain the complete database schema, tables, views, constraints, rules, etc, but the specific SET USER and GRANT commands that result in the database user privileges can be reviewed.
Note: The UNLOAD STRUCTURE command will also unload the database OWNER name. The generated file must be kept secure.
