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.

Regards,
Aage J.