1.

Define different function to get the current users details?

Answer»

Define different FUNCTION to GET the current USERS DETAILS?
Below are the different function to get current user detals with in-build function as given below:-
USER_ID(),USER_NAME(), SYSTEM_USER, SESSION_USER, CURRENT_USER, USER, SUSER_SID(), HOST_NAME()

And syntax is given below

select USER_ID(),USER_NAME(), SYSTEM_USER, SESSION_USER, CURRENT_USER, USER, SUSER_SID(), HOST_NAME()



Discussion

No Comment Found