December 1st, 2008
SESSION_USER (Authorization ID)
Posted by
admin in
G. ANSI Scalar Functions
Use SESSION_USER to retrieve the current active Authorization ID, if it differs from the USER.
Example:
SELECT SESSION_USER AS 'AuthID';
Result:
                   
> PostgreSQL, SQL Server, and Sybase support SESSION_USER.
> Access, DB2, MySQL, and Oracle don’t support SESSION_USER.
Â
