In Progress 10.2B on a Linux OS, if you have not added any users to the _USER table, users will connect to the database anonymously and their USERID value is set from their Linux User ID.
Adding a single user to the _USER table will force everyone to authenticate using credentials in the _USER table whenever they connect to the database. From then on, USERID function will return the user from _USER and not Linux.
Questions.
1. Is there a way to have one user in the _USER table and allow others to continue connecting anonymously?
2. Is there a way to force USERID to return the environment user ID, and not the one they authenticated with in _USER?
If we can't get a working solution to any of the above, we will have go go through and update over 1000 files replacing USERID with OS_GETENV("USER"). The recompilation of this alone would be a nightmare.