Subject Re: Get the username or uid of the current session's user
Author Aage Johansen
semprolbat wrote:
> Why is USER not shown when I do a "show table rdb$database;"?
> Are there other "hidden" fields in there?

USER isn't a field (in the table RDB$database). Think of it as a built-in
function. The RDB$database is just a single-record table that you need for
the select statement. If you did "select USER from YOURTABLE" where
YOURTABLE contains 1000 records you would receive the username 1000 times.

Aage J.