Currently in order for a user to log in to an xTuple database that user must exist both as a PostgreSQL user and an xTuple user in the usr table. This makes moving databases and manging users more difficult.
Move all the xTuple specific information in the usr table to user preferences and replace the usr table with a view to show the same information pulling from the PostgreSQL user table. Provide a system metric that would allow an admin to determine if any postgresql user may log in or if they must be specified as an active xTuple user for the specific database. Default set to Active only.
Steps to reproduce:
Read more at http://www.xtuple.org/mantis/view.php?id=8502