Progress
Language Reference
USERID Function
Returns the user ID of the current user.
SYNTAX
logical-dbname
The logical name of the database from which you want to retrieve the user ID. The logical database name must be a character string enclosed in quotes, or a character expression. If you do not specify this argument, the Compiler inserts the name of the database that is connected when the procedure is compiled. If you omit this argument and more than one database is connected, Progress returns a compiler error.
EXAMPLEThis one-line procedure displays the current user ID for the database with the DICTDB alias.
NOTES
- Use the Userid (-U) parameter together with the Password (-P) parameter. Progress checks the _User table for the user ID supplied with the -U parameter. When it finds that user ID, it compares the password supplied with the -P parameter with the password in the _User table. If the two passwords match, Progress assigns that user ID to the Progress session.
- When using the USERID function, Progress returns a compiler error under the following conditions:
- When specifying the logical-dbname argument, you must provide the name of the logical database, not the physical database.
- Every user who enters Progress is given an initial user ID.
Table 44 shows how Progress determines a user’s initial user ID on UNIX.
Table 45 shows how Progress determines a user’s initial user ID on Windows.
- After Progress starts running, you can use the SETUSERID function to change the current user ID.
- Progress user IDs are case sensitive.
- See the Progress Programming Handbook and the Progress Database Administration Guide and Reference for more information on security.
SEE ALSO
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |