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.

Comments are closed.

Sorry, the comment form is closed at this time.