_User, USERID(), and connecting to the database anonymous - Forum - OpenEdge Development - Progress Community

_User, USERID(), and connecting to the database anonymous

 Forum

_User, USERID(), and connecting to the database anonymous

  • 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.

  • In 11.0+ there is the concept of domains which is intended for this purpose – you can configure domain1 to use _user and domain2 to use the OS login.
     
    Not sure what your options in 10.2B are.