Kbase P142585: What is counted as a user by the OpenEdge database ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/03/2009 |
|
Status: Unverified
GOAL:
What is counted as a user by the OpenEdge database ?
GOAL:
Why does the same user have multiple user-id's in the database ?
GOAL:
How can the same user have different user numbers in the OpenEdge database ?
GOAL:
How does the user number relate to database connections ?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
From the database perspective, "user" and "connection" can be considered as synonyms - the database sees every connection as a seperate user, regardless of which process is making the connection and independent of user IDs provided by the operating system and/or the application.
Therefore:
- As far as the database is concerned it's login brokers, remote server processes and other supporitng processes show up as "users" when listing the open connections
- The same "user" on the OS level or application level will be seen as multiple users if this user makes multiple database connections. (Ie. multiple instances of the application running, or using different applications that end up connecting to the same database)
There may be some confusion depending on how the conenction data is queried. When using Promon -> User Control the user number is labeled "Usr".
However, when the same information is retrieved using the _Connect Virtual System Table (VST) it will by default be labelled as "User ID", which is easily confused with login names or such.