USERID function

Returns a character string representing the user ID of the current user.

Syntax

USERID [ ( logical-dbname ) ]

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, ABL returns a compiler error.

Example

This one-line procedure displays the current user ID for the database with the DICTDB alias:

r-userid.p

DISPLAY USERID("DICTDB") LABEL "You are logged in as" WITH SIDE-LABELS.

Notes

Use the Userid (-U) parameter together with the Password (-P) parameter. The AVM 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, the AVM assigns that user ID to the ABL session.
When using the USERID function, ABL returns a compiler error under the following conditions:
There is no database connected
You omit the logical-dbname argument and more than one database is currently connected
When specifying the logical-dbname argument, you must provide the name of the logical database, not the physical database.
Every user who enters ABL is given an initial user ID. Table 65 shows how ABL determines a user’s initial user ID on UNIX.

Table 65: Determining a UNIX user ID 

Are there records in the _User table?	Are the -U and -P startup options supplied?	User ID
NO	YES	Error: -U and -P not allowed unless there are entries in the _User table.
NO	NO	UNIX user ID.
YES	NO	"" (blank user ID).
YES	YES	If the -U userid and -P password match those in the _User table, use that user ID. Otherwise, do not assign a user ID.

Table 66 shows how ABL determines a user’s initial user ID in Windows.

Table 66: Determining a Windows user ID 

Are there records in the _User table?	Are the -U and -P startup options supplied?	User ID
NO	YES	Error: -U and -P not allowed unless there are entries in the _User table.
NO	NO	"" (blank user ID) or operating system user ID if available.
YES	NO	"" (blank user ID.
YES	YES	If the -U userid and -P password match those in the _User table, use that user ID. Otherwise, do not assign a user ID.

After ABL starts running, you can use the SETUSERID function to change the current user ID.
ABL user IDs are case sensitive.
See OpenEdge Development: Programming Interfaces and OpenEdge Data Management: Database Administration for more information on security.

See also

CONNECT statement, SETUSERID function

OpenEdge Release 10.2B

Copyright © 2009 Progress Software Corporation