On 2012-09-18 08:50, Alan McDonald wrote: > You can pump the data to another database shell without touching or knowing > the passwords > Alan
I'm not quite sure the data itself is valid (and whether pumping it to another database will fix the problem). I suspect there might be something wrong with the entries of RDB$USER_PRIVILEGES in my security2.fdb. There are some combinations of RDB$USER, RDB$PRIVILEGE and RDB$GRANT_OPTION for RDB$RELATION_NAME='RDB$ADMIN' which may be missing. I'll try to compare the contents of this system table with a valid one (i.e. one which allows privileged users to alter other users) and maybe I'll come up with an idea how to write the upgrade script myself. regards Tomasz -- __--==============================--__ __--== Tomasz Tyrakowski ==--__ __--== SOL-SYSTEM ==--__ __--== http://www.sol-system.pl ==--__ __--==============================--__